Revision: 13366
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at April 21, 2009 13:55 by hobeau
Initial Code
SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%foobar%'
AND ROUTINE_TYPE='PROCEDURE'
Initial URL
http://databases.aspfaq.com/database/how-do-i-find-a-stored-procedure-containing-text.html
Initial Description
search for text in your stored procedure
Initial Title
Search through stored procs
Initial Tags
Initial Language
SQL