sp_dropextendedproc System Stored Procedure

Drops an extended stored procedure.

Syntax

sp_dropextendedproc function_name

where

function_name

Specifies which extended stored procedure to drop.

Remarks

Executing sp_dropextendedproc drops the extended stored procedure name from the sysobjects table and removes the entry from the syscomments table.

Example

This example drops xp_diskfree.

sp_dropextendedproc xp_diskfree

Permission

Only the system administrator can use this procedure.

Tables Used

syscomments, sysobjects

See Also