Search for string in stored procedures - SQL Server

This query comes in pretty handy at times. Brute force way of looking for stored procedures having certain text (table name, views, functions), finding dependencies.


Select distinct object_name(id) from syscomments where charindex('String here', text) > 0 order by object_name(id)

Share