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

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.

Topic link iconTransact-SQL Syntax Conventions

Syntax

sp_helpextendedproc [ [@funcname = ] 'procedure' ]

Arguments

  • [ @funcname =] 'procedure'
    Is the name of the extended stored procedure for which information is reported. procedure is sysname, with a default of NULL.

Return Code Values

0 (success) or 1 (failure)

Result Sets

Column name Data Type Description

name

sysname

Name of the extended stored procedure.

dll

nvarchar(255)

Name of the DLL.

Remarks

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.

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_cmdshellextended stored procedure.

USE master;
GO
EXEC sp_helpextendedproc xp_cmdshell;
GO

See Also

Reference

sp_addextendedproc (Transact-SQL)
sp_dropextendedproc (Transact-SQL)
System Stored Procedures (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance