sp_stored_procedures

Description

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

Permissions

Any user can execute sp_stored_procedures.