SQL SERVER – Search Stored Procedure

If  you have the numbers of Stored Procedures in your database, it will be difficult to find a Stored Procedure you want to see / modify / changes in that, so for this issue you can search your Stored Procedure with below Syntex.

From this you can view Stored Procedure to display by text (code)

Syntax 01
sp_helptext @objname = 'sp_name'

From the below Syntax you can select all SP names and you can also search with Link operator too.

Syntax 02
Syntax
SELECT *  FROM sys.procedures;