Sp_stored_procedures - TSQL Tutorial

On Transact SQL language the sp_table_privileges is part of Catalog Stored Procedures and return a list of stored procedures in the current environment.

Sp_stored_procedures syntax:

sp_stored_procedures [ @sp_name = 'Procedure name.' ] ,
[ @sp_owner = 'The schema or database user who created.' ] ,
[ @sp_qualifier = 'Database name.' ] ;


Sp_stored_procedures example 1:

USE model;
GO EXEC sp_stored_procedures ;
GO

Sp_stored_procedures example 2:

USE model;
GO
EXEC sp_stored_procedures
@sp_name = '%',
@sp_owner = 'dbo',
@sp_qualifier = 'model';
GO