List all Stored Procedures on a SQL Database

Ever wanted to know what stored procedures exist on a database, but don’t have access to the SQL managment tools? The script below will produce a list of all the stored procedures on the current database.

SELECT Name AS StoredProcedureName
FROM sys.objects
WHERE type='P'