sp_stored_procedures

Returns information about one or more stored procedures.

sp_stored_procedures [sp_name [, sp_owner [, sp_qualifier]]]

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 about procedures that are owned by more than one user.

sp_qualifier: 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.