Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize


SQL Server 2000

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


sp_helpextendedproc [ [@funcname = ] 'procedure' ]


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


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.


Execute permissions default to the public role.

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

See Also



System Stored Procedures

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft