List all stored procedures in SQL Server database

Following SQL query gives you names of all the stored procedures in the active database:

SELECT SystemObjects.Name
FROM SYS.OBJECTS SystemObjects
WHERE SystemObjects.type = 'p'
ORDER BY SystemObjects.Name;