Transact-SQL Reference
sp_delete_operator
Removes an operator.
Syntax
sp_delete_operator [ @name = ] 'name'
[ , [ @reassign_to_operator = ] 'reassign_operator' ]
Arguments
[@name =] 'name'
Is the name of the operator to delete. name is sysname, with no default.
[@reassign_to_operator =] 'reassign_operator'
Is the name of an operator to whom the specified operator's alerts can be reassigned. reassign_operator is sysname, with a default of NULL.
Return Code Values
0 (success) or 1 (failure)
Result Sets
None
Remarks
When an operator is removed, all the notifications associated with the operator are also removed.
Permissions
Only members of the sysadmin fixed server role can execute sp_delete_operator.
Examples
This example deletes operator janetl.
USE msdb
EXEC sp_delete_operator 'janetl'