T-SQL search table columns for a particular field:

select sysobjects.name
from syscolumns
left join sysobjects on sysobjects.id = syscolumns.id
where syscolumns.name like 'Field_Name'
order by 1