sp_dropextendedproc (T-SQL)

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