How to: Modify Operators (Transact-SQL)

This topic describes how to modify a Microsoft SQL Server operator using stored procedures.

To modify a local operator

1. Execute sp_update_operator.

To modify an operator for a master SQL Server Agent

1. Execute sp_msx_defect to remove the target server from the master SQL Server Agent.

2. Execute sp_update_operator to change the operator.

See Also

Concepts

Viewing and Modifying Operators

Other Resources

System Stored Procedures (Transact-SQL)
sp_update_operator (Transact-SQL)
sp_msx_defect (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance