In SQL Server 2005 the T-SQL meta data function OBJECT_DEFINITION was introduced.  I like to use this command to search stored procedures for string values, such as table or column names. The BoL page is located at http://msdn.microsoft.com/en-us/library/ms176090.aspx. The following queries will return the definitions for VIEWS, UDFs and STORED PROCEDURES: USE AdventureWorks GO SELECT [...]