Get the list of stored procedures in sql server

SELECT * FROM SYS.procedures WHERE NAME NOT LIKE 'SP_%DIAGRAM%' ORDER BY modify_date desc

OR

SELECT * FROM sys.all_objects where type='p' and NAME NOT LIKE 'SP_%DIAGRAM%' ORDER BY create_date desc