sp_stored_procedures

Returns information about one or more stored procedures.

Syntax

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

Usage

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 returns information about stored procedures in the current database only.

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.

Permissions

Any user can execute sp_stored_procedures.