SQL Server searches for all stored procedures that contain a specific text.

That's all.

The stored procedure calls mup_GetA (I erased the project-related names)

You can view objects dependent on mup_GetA through the functions provided by sqlserver graphics manager.

The result is a bit confusing. I didn't list mup_GetB (I used SQL server 2005)


The solution is as follows:
Method 1:
Choose Database Management> right-click Database> tasks> Generate Scripts> .....
Export all stored procedures to the file, and then ctrl + F to find
Method 2:
Copy codeThe Code is as follows:
SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '% text %'
AND ROUTINE_TYPE = 'processed'

Replace text with the content you want to find

Method 3:
Copy codeThe Code is 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 the content you want to find

Finished