Events
Sep 15, 6 AM - Sep 17, 3 PM
The best SQL community-led learning event. Sept 2025. Save €200 with code FABLEARN.
Get registeredNote
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 Common language runtime (CLR) integration instead.
Transact-SQL syntax conventions
sp_helpextendedproc [ [ @funcname = ] N'funcname' ]
[ ; ]
The name of the extended stored procedure for which information is reported. @funcname 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 @funcname is specified, sp_helpextendedproc reports on the specified extended stored procedure. When this parameter isn't 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
EXECUTE sp_helpextendedproc;
GO
The following example reports on the xp_cmdshell extended stored procedure.
USE master;
GO
EXECUTE sp_helpextendedproc xp_cmdshell;
GO