Drops an extended stored procedure.
sp_dropextendedproc [@functname =] 'procedure'
0 (success) or 1 (failure)
None
Executing sp_dropextendedproc drops the extended stored procedure name from the sysobjects table and removes the entry from the syscomments table.
sp_dropextendedproc cannot be executed inside a transaction.
Only members of the sysadmin fixed server role can execute sp_dropextendedproc.
This example drops the xp_diskfree extended stored procedure.
Note This extended stored procedure must already exist for this example to work without returning an error message.
USE master
EXEC sp_dropextendedproc 'xp_hello'
sp_addextendedproc | System Stored Procedures |
sp_helpextendedproc |