How can we help you today? How can we help you today?

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
0

Comments

1 comment

Sort by
  • rjpaulsen
    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 [ROUTINE_NAME]
    rjpaulsen
    0

Add comment

Please sign in to leave a comment.