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.

System_CAPS_ICON_note.jpg Note


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.

0 (success) or 1 (failure)

Column nameData TypeDescription
namesysnameName of the extended stored procedure.
dllnvarchar(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  

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

Community Additions

ADD
Show: