I used to have a script that I ran in Query Analyzer called Where_Am_I. It would allow me to search a database for any reference to string that I passed as a parameter. i.e. Where_Am_I 'UserName' might return a list of all the tables that contain a field called UserName and all stored procedures that have a reference to this field.
I was hoping someone might have a sql script like that they can provide.