sp_stored_procedures


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:

sp_stored_procedures

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