| title | sp_helpextendedproc (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/14/2017 | ||
| ms.prod | sql | ||
| ms.prod_service | database-engine | ||
| ms.reviewer | |||
| ms.technology | system-objects | ||
| ms.topic | language-reference | ||
| f1_keywords |
|
||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | 7e1f017e-c898-4225-b375-6a73ef9aac7b | ||
| author | stevestein | ||
| ms.author | sstein |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]
Reports the currently defined extended stored procedures and the name of the dynamic-link library (DLL) to which the procedure (function) belongs.
Note
[!INCLUDEssNoteDepFutureAvoid] Use CLR Integration instead.
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 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.
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
sp_addextendedproc (Transact-SQL)
sp_dropextendedproc (Transact-SQL)
System Stored Procedures (Transact-SQL)