Export (0) Print
Expand All
Expand Minimize
1 out of 1 rated this helpful - Rate this topic

sp_dropextendedproc

SQL Server 2000

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.