How to get a list of stored procedures in sql server

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