From my old blog, October 9, 2008. No longer maintained.

Find text in stored procedures

The original is on archive.org.

Here is a simple SQL query that will look in your stored procedures and return any that finds “yourtext”.

SELECT ROUTINE_NAME, ROUTINE_DEFINITION
    FROM INFORMATION_SCHEMA.ROUTINES
    WHERE ROUTINE_DEFINITION LIKE ‘%yourtext%’
    AND ROUTINE_TYPE=’PROCEDURE’

All old blog posts