Use this to find out where a given field name or column reside and is being used in SQL Server.
select so.name
from sysobjects so inner join syscolumns sc
ON so.id = sc.id where sc.name = 'YourColumnNameGoesHere'
or
select so.name, sc.name
from sysobjects so inner join syscolumns sc
ON so.id = sc.id where sc.name like '%YourPartialColumnNameGoesHere%'
or
Select table_name from information_Schema.columns where column_name='yourCol'