To search stored procedures using MS-SQL you can use the snippet below.
Sample MSSQL
SELECT Name FROM sys.procedures WHERE name LIKE '%StoredProcName%'
To search stored procedures using MS-SQL you can use the snippet below.
SELECT Name FROM sys.procedures WHERE name LIKE '%StoredProcName%'
To get a list of all storedprocedures in a Database you can use te following snippet.
select * from Testdatabase.information_schema.routines where routine_type = 'PROCEDURE' ORDER BY ROUTINE_NAME ASC