Seek for column name all objects name


 select s.name from sysobjects sinner join sys.schemas c on c.schema_id = s.uidinner join syscolumns l on l.id = s.idwhere l.name like '%produc%key%'