Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
sp_helpextendedproc (Transact-SQL)
Collapse the table of content
Expand the table of content

sp_helpextendedproc (Transact-SQL)

 

Applies To: SQL Server 2014, SQL Server 2016 Preview

Reports the currently defined extended stored procedures and the name of the dynamic-link library (DLL) to which the procedure (function) belongs.

System_CAPS_noteNote

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.

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

Community Additions

ADD
Show:
© 2015 Microsoft