sp_helpextendedproc (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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).|

Topic link icon Transact-SQL Syntax Conventions


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)

Result Sets

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;  
EXEC sp_helpextendedproc;  

B. Reporting help on a single extended stored procedure

The following example reports on the xp_cmdshell extended stored procedure.

USE master;  
EXEC sp_helpextendedproc xp_cmdshell;  

See Also

sp_addextendedproc (Transact-SQL)
sp_dropextendedproc (Transact-SQL)
System Stored Procedures (Transact-SQL)