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