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.
The permission checks for sp_dropextendedproc differ based on your granular permissions settings.
Granular permissions enabled |
With granular permissions enabled, you must be a user with manage any ESP privilege. |
Granular permissions disabled |
With granular permissions disabled, you must be a user with sa_role. |
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
