Get list of all stored procedures in SQL Server 2005

USE

SELECT NAME
FROM SYS.OBJECTS
WHERE TYPE = 'P'