Drops an operator.
sp_dropoperator name
where
This stored procedure must be run from the msdb database.
Dropping an operator also drops all of the operator's notifications. If the specified operator is the "Fail-Safe Operator," the operator cannot be dropped.
The "Fail-Safe Operator" is the operator who is notified if none of the pager notifications can be sent. The "Fail-Safe Operator" is defined using SQL Enterprise Manager, and SQL Enterprise Manager provides an easy, graphical way to manage the entire alerting system. Using SQL Enterprise Manager is the recommended way to configure your alert infrastructure.
This example removes all of the operator information for John Doe.
sp_dropoperator 'John Doe'
Only the system administrator can use this procedure.
sysnotifications, sysoperators
| sp_addoperator | sp_updateoperator |
| sp_helpoperator |