Posted By

SkyeBianca on 12/06/10


Tagged

sql sqlserver StoredProcedure textsearch


Versions (?)

SQL Server - Find text in stored proc


 / Published in: SQL
 

  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.