sp_dropextendedproc (Transact-SQL)

  • Article

Applies to: SQL Server

Drops an extended stored procedure.

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

Syntax

sp_dropextendedproc [ @functname = ] N'functname'
[ ; ]

Arguments

[ @functname = ] N'functname'

The name of the extended stored procedure to drop. @functname is nvarchar(517), with no default.

Return code values

0 (success) or 1 (failure).

Result set

None.

Remarks

Executing sp_dropextendedproc drops the user-defined extended stored procedure name from the sys.objects catalog view, and removes the entry from the sys.extended_procedures catalog view. This stored procedure can be run only in the master database.

sp_dropextendedproc doesn't drop system extended stored procedures. Instead, the system administrator should deny EXECUTE permission on the extended stored procedure to the public role.

sp_dropextendedproc can't be executed inside a transaction.

Permissions

Only members of the sysadmin fixed server role can execute sp_dropextendedproc.

Examples

The following example drops the xp_hello extended stored procedure. This extended stored procedure must already exist, or the example returns an error message.

USE master;
GO
EXEC sp_dropextendedproc 'xp_hello';

Related content