Skip to content

Latest commit

 

History

History
90 lines (64 loc) · 2.67 KB

sp-helpextendedproc-transact-sql.md

File metadata and controls

90 lines (64 loc) · 2.67 KB
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs
sp_helpextendedproc (Transact-SQL)
Reports the currently defined extended stored procedures and the name of the dynamic-link library (DLL) to which the procedure (function) belongs.
markingmyname
maghan
randolphwest
08/22/2024
sql
system-objects
reference
sp_helpextendedproc
sp_helpextendedproc_TSQL
sp_helpextendedproc
TSQL

sp_helpextendedproc (Transact-SQL)

[!INCLUDE 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

[!INCLUDE ssNoteDepFutureAvoid] Use Common language runtime (CLR) integration instead.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

sp_helpextendedproc [ [ @funcname = ] N'funcname' ]
[ ; ]

Arguments

[ @funcname = ] N'funcname'

The name of the extended stored procedure for which information is reported. @funcname is sysname, with a default of NULL.

Return code values

0 (success) or 1 (failure).

Result set

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

Remarks

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.

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

Related content