Reports the currently defined extended stored procedures and the name of the dynamic-link library (DLL) to which the procedure (function) belongs.
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use CLR Integration instead.
|Applies to: SQL Server ( SQL Server 2008 through current version).|
sp_helpextendedproc [ [@funcname = ] 'procedure' ]
[ @funcname =] 'procedure'
Is the name of the extended stored procedure for which information is reported. procedure is sysname, with a default of NULL.
Return Code Values
0 (success) or 1 (failure)
|Column name||Data Type||Description|
|name||sysname||Name of the extended stored procedure.|
|dll||nvarchar(255)||Name of the DLL.|
When procedure is specified, sp_helpextendedproc reports on the specified extended stored procedure. When this parameter is not supplied, sp_helpextendedproc returns all extended stored procedure names and the DLL names to which each extended stored procedure belongs.
Permission to execute sp_helpextendedproc is granted to public.
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