Export (0) Print
Expand All
Expand Minimize

sp_dropextendedproc (Transact-SQL)

Drops an extended stored procedure.

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.

Topic link icon Transact-SQL Syntax Conventions

sp_dropextendedproc [ @functname = ] 'procedure' 

[ @functname =] 'procedure'

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

0 (success) or 1 (failure)

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.

In SQL Server 2012 sp_dropextendedproc does not drop system extended stored procedures. Instead, the system administrator should deny EXECUTE permission on the extended stored procedure to the public role.

sp_dropextendedproc cannot be executed inside a transaction.

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

The following example drops the xp_hello extended stored procedure.

Note Note

This extended stored procedure must already exist, or the example will return an error message.

USE master;
GO
EXEC sp_dropextendedproc 'xp_hello';
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft