Chapter 1: System Procedures

sp_dropextendedproc

Removes an extended stored procedure (ESP).

sp_dropextendedproc esp_name

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.

Values in event and extrainfo columns from the sysaudits table are:

Event	Audit option	Command or access audited	Information in extrainfo
38	exec_procedure	Execution of a procedure	Roles – Current active roles Keywords or options – NULL Previous value – NULL Current value – NULL Other information – All input parameters Proxy information – Original login name, if set proxy in effect