Export (0) Print
Expand All
Expand Minimize

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.

Note 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 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;
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

Community Additions

ADD
Show:
© 2014 Microsoft