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.
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 |
|
Commands drop procedure
System procedures sp_addextendedproc, sp_freedll, sp_helpextendedproc
