SQL Server to find all stored procedures that contain a text

Let me show you the picture.

The above figure stored procedure called Mup_geta (I wiped out the name associated with the project)

The above illustration uses the SQL Server Graphics manager's own features to view objects that depend on Mup_geta.

The result was a bit shocking and it didn't list MUP_GETB (I'm using SQL Server 2005)


Here's how to fix it
Method 1:
Open the database management interface-> Right click on the database->tasks->generate scripts-> ...
Export all stored procedures to a file, and then ctrl+f find
Method 2:
Copy Code code as follows:
SELECT Routine_name, Routine_definition
From INFORMATION_SCHEMA. Routines
WHERE routine_definition like "%text%"
and routine_type= "PROCEDURE"

Replace text with what you're looking for

Method 3:
Copy Code code as follows:
Select Name
From sysobjects O, syscomments s
where o.id = S.id
and text like "%text%"
and O.xtype = "P"

Replace text with what you're looking for

Complete