SQL SERVER – 2005 – List All Stored Procedure in Database

Run following simple script on SQL Server 2005 to retrieve all stored procedure in database.

SELECT *
FROM sys.procedures;

This will ONLY work with SQL Server 2005.

sp_helptext @sp_spname