How to find field in a SQL Server 2005 DB 1

[rahulroy08]

Hi,

I'm looking for a particular field "Booking Role" and "Title" in my SQL Server 2005 DB. I'm not sure in which table it is. Can someone help me with the easiest and the quickest possible way to find the field from a huge DB with many tables.

Your help is appreciated.


Rahul.

 

[gmmastros]

Select * 
From   Information_Schema.Columns 
Where  Column_Name = 'Booking Role'

-George

"the screen with the little boxes in the window." - Moron