sp_helpextendedproc System Stored Procedure

Displays the currently defined extended stored procedures and the name of the dynamic-link library to which the function belongs.

Syntax

sp_helpextendedproc [function_name]

where

function_name
Specifies which extended stored procedure to display information about.

Remarks

When function_name is specified, sp_helpextendedproc reports on the specified extended stored procedure. When no parameter is supplied, sp_helpextendedproc reports on all extended stored procedures.

Examples

A.    Help on All Extended Stored Procedures

This example reports on all extended stored procedures.

sp_helpextendedproc
B.    Help on a Single Extended Stored Procedure

This example reports on the xp_cmdshell extended stored procedure.

sp_helpextendedproc xp_cmdshell

Permission

Execute permission defaults to the system administrator and can be transferred.

Table Used

syscomments, sysobjects

See Also

sp_addextendedproc sp_dropextendedproc