Search Stored Procedures Code

Submitted by:David Villa

Date added:12 January, 2013

Category:SQL

Search the source code of all stored procedures.

Tags: search stored procedure

Code Snippet:

    SELECT TOP 1000
[ROUTINE_NAME]
,[ROUTINE_DEFINITION]
,ROUTINE_TYPE
FROM ebiz.[INFORMATION_SCHEMA].[ROUTINES]
WHERE ROUTINE_TYPE IN ('PROCEDURE', 'FUNCTION')
AND [ROUTINE_DEFINITION] LIKE '%something to find%'
 
 

Comments