Find all Procedures in a Database

Posted Date: 20 Nov 2008	Resource Type: Articles	Category: Databases
Author: gururajan	Member Level: Gold
Rating:	Points: 8

SQL SERVER 2000:

select name from sysobjects where type='P'

SQL SERVER 2005:

select name from sys.procedures

You can find whether the stored procedure execution is used in replication or if the stored procedure is a startup procedure. Execute the following queries:

select name from sys.procedures where is_execution_replicated=1

select name from sys.procedures where is_auto_executed=0

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

Find all procedures .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Find all database names in a SQL Server instance
	Previous Resource: Command Bulider Object prepares to update commands in Dataset
	Return to Discussion Resource Index
	Post New Resource
	Category: Databases

Post resources and earn money!

Related Resources