Stupid SQL Tricks

Search for all instances of a column name:

    SELECT OBJECT_NAME(OBJECT_ID), definition
    FROM sys.sql_modules
    WHERE definition LIKE '%' + 'ColumnName' + '%'
    GO