Query that returns list of all Stored Procedures in an MS SQL database

select * from information_schema.routines
where routine_type = 'PROCEDURE'