sp_helpextendedproc (Transact-SQL)

Article
02/28/2023

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 CLR Integration instead.

Transact-SQL syntax conventions

Syntax

  
sp_helpextendedproc [ [@funcname = ] 'procedure' ]

Arguments

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

Result Sets

Column name	Data Type	Description
name	sysname	Name of the extended stored procedure.
dll	nvarchar(255)	Name of the DLL.

Remarks

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.

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