Removes an extended stored procedure (ESP).
sp_dropextendedproc esp_name
is the name of the extended stored procedure to be dropped.
Removes xp_echo:
sp_dropextendedproc xp_echo
sp_dropextendedproc must be executed from the master database.
The esp_name is case sensitive. It must precisely match the name with which the ESP was created.
Only a System Administrator can execute sp_dropextendedproc.
Commands drop procedure
System procedures sp_addextendedproc, sp_freedll, sp_helpextendedproc