How can we find the stored procedure in the database if we have just some idea of the procedure name?
Store procedure can be searched via 2 ways:
Via GUI:
1. Connect to server
2. Connect to the database
3. Click on the database and expand--> Click on Programmability --> Right Click on stored Procedure --> Click on Filter--> Click on Add-->
A new dialog box will get open--> write a procedure name for which you have an idea
Via Command:
1. Connect to server
2. Connect to the database
Query:
SELECT name FROM sys.procedures WHERE name LIKE '%ProcName%'
Execute the query( using F5/ execute button)