sp_stored_procedures returns information about one or more stored
procedures.
Syntax
server_name... sp_stored_procedures [sp_name [, sp_owner
[, sp_qualifier]]]
Parameters
- sp_name – is the name of the stored procedure. Use wildcard
characters to request information about more than one stored procedure.
- sp_owner – is the owner of the stored procedure. Use wildcard characters to request information for more
than one user.
- sp_qualifier – is the name of the package, or NULL.
Usage
- sp_stored_procedures returns
information about stored procedures in all packages unless
sp_qualifier is specified.
- sp_stored_procedures can return the name of stored procedures for which the
current user does not have execute permission.
Permissions
Any user can execute sp_stored_procedures.