Posted By

hoffstein on 10/14/08

Tagged

1 person have marked this snippet as a favorite

/ Published in: SQL

Searches all stored procedures and functions for a given keyword.

SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%keyword%'

Comment:

You need to login to post a comment.