sp_helpextendedproc (Transact-SQL)
Applies to:
SQL Server
Reports the currently defined extended stored procedures and the name of the dynamic-link library (DLL) to which the procedure (function) belongs.
Note
This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use Common Language Runtime Integration instead.
Transact-SQL syntax conventions
Syntax
sp_helpextendedproc [ [ @funcname = ] N'funcname' ]
[ ; ]
Arguments
[ @funcname = ] N'funcname'
The name of the extended stored procedure for which information is reported. @funcname is sysname, with a default of NULL
.
Return code values
0
(success) or 1
(failure).
Result set
Column name | Data type | Description |
---|---|---|
name |
sysname | Name of the extended stored procedure. |
dll |
nvarchar(255) | Name of the DLL. |
Remarks
When @funcname is specified, sp_helpextendedproc
reports on the specified extended stored procedure. When this parameter isn't supplied, sp_helpextendedproc
returns all extended stored procedure names and the DLL names to which each extended stored procedure belongs.
Permissions
Permission to execute sp_helpextendedproc
is granted to public.
Examples
A. Reporting help on all extended stored procedures
The following example reports on all extended stored procedures.
USE master;
GO
EXEC sp_helpextendedproc;
GO
B. Reporting help on a single extended stored procedure
The following example reports on the xp_cmdshell
extended stored procedure.
USE master;
GO
EXEC sp_helpextendedproc xp_cmdshell;
GO