How can we find the stored procedure in the database if we have just some idea of the procedure name?

Question

Rachit Gupta · Accepted Answer

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)

Your answer