SQL Server Query to Search Text in Stored Procedure

Hello Friends,

This post contains one query, by using that you can make search for any text in your Stored
Procedure Or Triggers,

Here is the query..

Use TempDatabase

SELECT ROUTINE_NAME, ROUTINE_DEFINITION 
FROM INFORMATION_SCHEMA.ROUTINES 
WHERE ROUTINE_DEFINITION LIKE '%proc_%' 
AND ROUTINE_TYPE='PROCEDURE'

Frist Select the Database by Use prefix,like below
use TempDatabase

Then copy this query in your query browser of SQL server,

SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%proc_%'
AND ROUTINE_TYPE='PROCEDURE'
and just press F5, to run this query

Let me know, if you have any query..

Thanks Hope this post will help you, if yes please put comment below of this page,

Rajesh Singh,

Senior Asp.Net Developer

Email: raj143svmit@gmail.com

e-Procurement Technologies Ltd (India)

www.abcprocure.com