SQL Server to find all stored procedures that contain a text _mssql

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-&gt ...
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