SQL to Search All Tables for Column Name

declare @search_string  varchar(50)

set @search_string = ''

SELECT table_name=sysobjects.name,
column_name=syscolumns.name,
datatype=systypes.name,
length=syscolumns.length
FROM sysobjects
JOIN syscolumns ON sysobjects.id = syscolumns.id
JOIN systypes ON syscolumns.xtype=systypes.xtype
WHERE sysobjects.xtype='U'
and syscolumns.name LIKE '%' + @search_string + '%'
ORDER BY sysobjects.name,syscolumns.colid

Credit to: http://codesnippets.joyent.com/posts/show/337