sp_dropextendedproc

Description

Removes an extended stored procedure (ESP).

Syntax

sp_dropextendedproc esp_name

Parameters

esp_name

is the name of the extended stored procedure to be dropped.

Examples

Example 1

Removes xp_echo:

sp_dropextendedproc xp_echo

Usage

Permissions

Only a System Administrator can execute sp_dropextendedproc.

See also

Commands drop procedure

System procedures sp_addextendedproc, sp_freedll, sp_helpextendedproc