Just figured out a neat way to quickly search metadata easily when working with SQL. If you use SQL Prompt from Red Gate, I suggest adding the following as a new snippet (I use FF):

1
2
3

SELECT RTRIM(so.name) + '.' + RTRIM(sc.name) AS DBObjectName 
FROM SYSOBJECTS so INNER JOIN syscolumns sc ON so.id = sc.id
WHERE so.type = 'U' AND (sc.name+' '+so.name) LIKE '%

Very handy to always have search ready at your fingertips, especially when working with data extraction from unfamiliar databases.