sp_stored_procedures

Returns information about one or more stored procedures.

Syntax

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

Parameters

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.

Related reference
sp_server_info