sp_dropextendedproc

Drops an extended stored procedure.

Syntax

sp_dropextendedproc [ @functname = ] 'procedure'

Arguments

[@functname =] 'procedure'

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

Return Code Values

0 (success) or 1 (failure)

Result Sets

None

Remarks

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.

Permissions

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

Examples

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'

See Also

sp_addextendedproc

sp_helpextendedproc

System Stored Procedures