Click here to hide categories Click here to show left categories

User: Home          welcome : Guest          Log In / Register here     




how to get list of stored procedures in sql server 2005

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%'

Share this article   |    Print    |    Article read by 1878 times
Author:
Rohit kakria
I am software developer, moderator of xpode.com
Related Articles:
Related Interview Questions: No related interview question