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:CopyCodeThe 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