Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Stored Proc to list stored procs

Status
Not open for further replies.

spazman

Programmer
May 29, 2001
500
CA
I was going to make one but then figured there is already a SP to list SP's in the current DB. But do you think I can find it? Is there one or away to get one?
 
You can find one in the master database:
exec sp_stored_procedures
 
That works thanks CherylD, this also works

select name from sysobjects WHERE xtype = 'p' AND status >= '0'

Seems system SP's have a negative status number.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top