SQL Server 2005 - List all stored procedures in a database.

SQL Server 2005

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

 

USE AdventureWorks

GO

SELECT * FROM sys.procedures;