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.