// Lists all the stored procedures in the DB
exec sp_stored_procedures
// Retrieves the Stored Procedure text to the output window.
EXEC sp_helptext N’spnamen’;
// Lists all the stored procedures in the DB
exec sp_stored_procedures
// Retrieves the Stored Procedure text to the output window.
EXEC sp_helptext N’spnamen’;
good one!