SELECT t.name AS table_name,
       SCHEMA_NAME(schema_id) AS schema_name,
       c.name AS column_name
FROM   sys.tables AS t
INNER JOIN sys.columns c 
  ON  t.OBJECT_ID = c.OBJECT_ID
WHERE c.name LIKE '%A Column Name%'
ORDER BY schema_name,
         table_name;