sp_helpextendedproc (T-SQL)

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

Syntax

sp_helpextendedproc [[@funcname =] 'procedure']

Arguments

[@funcname =] 'procedure': Is the name of the extended stored procedure for which to display information. procedure is sysname, with a default of NULL.

Return Code Values

0 (success) or 1 (failure)

Result Sets

Column name	Data Type	Description
name	sysname	Name of the extended stored procedure
dll	nvarchar(255)	Name of the dynamic link library

Remarks

When procedure is specified, sp_helpextendedproc reports on the specified extended stored procedure. When not supplied, sp_helpextendedproc returns all extended stored procedure names and the DLL names to which each extended stored procedure belongs.

Permissions

Execute permissions default to the sysadmin fixed server role, and can be transferred.

Examples

A. Report help on all extended stored procedures

This example reports on all extended stored procedures.

USE master

EXEC sp_helpextendedproc

B. Report help on a single extended stored procedure

This example reports on the xp_cmdshell extended stored procedure.

USE master

EXEC sp_helpextendedproc xp_cmdshell

sp_addextendedproc	System Stored Procedures
sp_dropextendedproc