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.
