My colleagues asked me hundred times, how to find a particular columns, table name, stored procedure, views in the database.
Always forgot to remember one query. So for them only
Below query you can any table, stored procedure or views who ever have that expression as a column or object name...... http://blog.joggee.com/?p=119