How to get list of stored procedures in sql server 2005 and How to select the data base from query analyzer and How to get specific store procedure from query analyzer

When we need to get the list of store procedure in sql server 2005 then in that case we will write the below code in Query manager.

We may use the below command to select the database if required

use [Database Name]

Command for show the list of store procedure

SELECT * FROM sys.procedures

If you want to select the specific store procedure or you want the detail of specific procedure or If you want to Alter or modify the store procedure. Then we will write the below command to select the store procedure.

sp_helptext [StoreprocedureName]

Get the list of Store Procedures from a database

 

SELECT * FROM dbo.SYSOBJECTS WHERE TYPE='P'

Get the list of Store Procedures having specific word from a database

 

SELECT * FROM dbo.SYSOBJECTS WHERE TYPE='P' AND NAME LIKE '%MyProcedure%'