Search in Stored Procs

Description: Searches the contents of Stored Procs for a given phrase

Shortcut: ssp (Search Stored Procs)

Code:

SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '{%}foobar{%}'

atomicbomb 17 years ago

Comments

1 comment

This is the one I use:

SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES 
WHERE ROUTINE_DEFINITION LIKE '%$CURSOR$%' 
AND ROUTINE_TYPE='PROCEDURE'
ORDER BY &#91;ROUTINE_NAME&#93;

rjpaulsen 17 years ago