Tuesday, March 30, 2010

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

No comments:

Post a Comment