Posted By

charmcitycoder on 07/27/09


Tagged

sql search stored procedure Microsoft procedures sqlserver


Versions (?)

Search stored procedures for string


 / Published in: SQL
 

URL: http://snippets.dzone.com/posts/show/3905

  1. SELECT
  2. ROUTINE_NAME,
  3. ROUTINE_DEFINITION
  4. FROM
  5. INFORMATION_SCHEMA.ROUTINES
  6. WHERE
  7. ROUTINE_DEFINITION LIKE '%whatev%'
  8. ORDER BY
  9. ROUTINE_NAME

Report this snippet  

You need to login to post a comment.