List of Stored Procedure in a database

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

List of Stored Procedure in a database

Author

Topic

karan@talash.net
Starting Member

12 Posts

Posted - 2002-07-01 : 01:31:37

Hi,
I want to get the list of stored procedures in a sql server database.How is it possibel.I know the name of all stored procedures are stored in a system table,but what is the name of the table.
Regards
Karan Bajoria

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2002-07-01 : 01:39:49

Hi there

Try this



select name

from sysobjects

where type = 'p' and name not like 'dt_%' 

order by name

Damian

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources