Script to list out all User Stored Procedures in database

SELECT NAME
 ,type
FROM dbo.sysobjects
WHERE (type = 'P')
ORDER BY NAME