List of Stored Procedures

How do I get a list of the stored procedures currently in the database? Is there a quick way to edit them?

Thank you!

Hi,

if you just want to use a query you can use the INFORMATION_SCHEMA.Views to get the information. If you want to retrieve the data programmtically and as typed objects you should have a look on the SMO classes.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

select * from sys.objects where type = 'P'

Thanks
Laurentiu