Skip to content

Instantly share code, notes, and snippets.

@tax

tax/Search for text in stored procedure

Created August 28, 2009 09:00
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save tax/176846 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save tax/176846 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Search for text in stored procedure
/*http://databases.aspfaq.com/database/how-do-i-find-a-stored-procedure-containing-text.html*/
SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%foobar%'
AND ROUTINE_TYPE='PROCEDURE'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment