Posted By

hobeau on 04/21/09


Tagged

stored procedure


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

flurk118


Search through stored procs


 / Published in: SQL
 

URL: http://databases.aspfaq.com/database/how-do-i-find-a-stored-procedure-containing-text.html

search for text in your stored procedure

  1. SELECT ROUTINE_NAME, ROUTINE_DEFINITION
  2. FROM INFORMATION_SCHEMA.ROUTINES
  3. WHERE ROUTINE_DEFINITION LIKE '%foobar%'
  4. AND ROUTINE_TYPE='PROCEDURE'

Report this snippet  

You need to login to post a comment.