How to get a list of stored procedures in sql server

Thursday, 28 January 2010

To get a list of stored procedures in sql server you can use the following query Select * from sysobjects where type = 'P' and category = 0