SQL Script To Find For A Particular Column In A Database

SELECT so.name as tablename, sc.name as columnname from sysobjects so

JOIN syscolumns sc

on sc.id = so.id and sc.name like '<<Column Name>>'

and so.xtype = 'U'