Applies To: SQL Server 2014, SQL Server 2016 Preview
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).
- [ @funcname =] 'procedure'
Is the name of the extended stored procedure for which information is reported. procedure is sysname, with a default of NULL.
0 (success) or 1 (failure)
Name of the extended stored procedure.
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.
The following example reports on all extended stored procedures.
USE master; GO EXEC sp_helpextendedproc; GO
The following example reports on the xp_cmdshell extended stored procedure.
USE master; GO EXEC sp_helpextendedproc xp_cmdshell; GO