Posted By

dmilligan on 12/27/12


Tagged

sql stored procedure


Versions (?)

Search Stored Prcedures Code


 / Published in: SQL
 

Search the source code of all stored procedures.

  1. SELECT TOP 1000
  2. [ROUTINE_NAME]
  3. ,[ROUTINE_DEFINITION]
  4. ,ROUTINE_TYPE
  5. FROM ebiz.[INFORMATION_SCHEMA].[ROUTINES]
  6. WHERE ROUTINE_TYPE IN ('PROCEDURE', 'FUNCTION')
  7. AND [ROUTINE_DEFINITION] LIKE '%something to find%'

Report this snippet  

You need to login to post a comment.