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
sp_addextendedproc System Stored Procedures
sp_helpextendedproc  

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.