How to: Designate an Events Forwarding Server (SQL Server Management Studio)

This topic describes how to designate a server to which Microsoft SQL Server forwards events.

To designate an events forwarding server

  1. In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.

  2. Right-click SQL Server Agent and select Properties. Click the Advanced page.

  3. Under SQL Server event forwarding, check Forward events to a different server.

  4. In the Server list, click a server, and then one of the following:

    • Click Unhandled events to forward only the events that have not been handled by local alerts.
    • Click All events to forward all events regardless of whether they have been handled by local alerts.
  5. In the If event has severity at or above list, click the severity level at which events are forwarded to the selected server.

See Also

Other Resources

SQL Server Agent

Help and Information

Getting SQL Server 2005 Assistance