Returns information about one or more stored procedures.
sp_stored_procedures [sp_name [, sp_owner [, sp_qualifier]]]
is the name of the stored procedure. Use wildcard characters to request information about more than one stored procedure.
is the owner of the stored procedure. Use wildcard characters to request information about procedures that are owned by more than one user.
is the name of the database. This can be the current database or NULL.
sp_stored_procedures returns information about stored procedures in the current database only.
The results set for sp_stored_procedures is:
Column |
Datatype |
Description |
|---|---|---|
procedure_qualifier |
varchar(30) |
The name of the database. |
procedure_owner |
varchar(30) |
|
procedure_name |
varchar(41) |
NOT NULL. |
num_input_params |
int |
NOT NULL. Always returns -1. |
num_output_params |
int |
NOT NULL. The value >= 0 shows the number of parameters; -1 means the number of parameters is indeterminate. |
num_result_sets |
int |
NOT NULL. Always returns -1. |
remarks |
varchar(254) |
NULL. |
sp_stored_procedures can return the name of stored procedures for which the current user does not have execute permission. However, if the server attribute accessible_sproc is “Y” in the results set for sp_server_info, only stored procedures that are executable by the current user are returned.
Any user can execute sp_stored_procedures.
