sp_delete_operator (T-SQL)

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'

See Also