• Article

ForwardAlways Property

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The ForwardAlways property controls event forwarding for SQL Server Agent.

Syntax

object.ForwardAlways [=value]

Parts

  • object
    An expression that evaluates to an object in the Applies To list

  • value
    TRUE or FALSE

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetForwardAlways(LPBOOL pRetVal);
HRESULT SetForwardAlways(BOOL NewValue);

Remarks

SQL Server Agent can be configured to forward events to another instance of Microsoft SQL Server. By default, when an event forward server is defined, the forwarding server forwards only events for which no alert notification mechanism exists.

If TRUE, all events on the forwarding server are directed to the forwarded server regardless of the presence of notifications for the event on the forwarding server.

If FALSE, only events with no alert notification available are forwarded from the forwarding server.

Applies To:

AlertSystem Object