advanced code snippet search

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

Expand | Embed | Plain Text 
  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.