Er. alokpandey's Blog

SQL query that returns the names of all the stored procedures in an MS SQL database

Posted in Uncategorized by Alok Kumar Pandey on November 10, 2010

SELECT name, type FROM dbo.sysobjects WHERE (type = ‘P’)

select *
from dbo.sysobjects where xtype = ‘P’ and status >0

SELECT *
FROM sys.objects
WHERE objectproperty(object_id, N’IsMSShipped’) = 0
AND objectproperty(object_id, N’IsProcedure’) = 1

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: