sp_stored_procedures is a system stored procedure which will result in all the stored procedures that are present in a particular database.

That is sp_stored_procedures results in all system stored procedures, user defined stored procedures and extended stored procedures information in a database.

Syntax for sp_stored_procedures is:


Example :

Following picture represents the execution result  of sp_stored_procedures stored procedure in EXAMPLE database.

This entry was posted in . Bookmark the permalink.

Leave a reply