Share via

Application.LogNotificationText Property

  • Article

Gets or sets a Boolean value that configures the distributor to log all notification text from the delivery protocol for all notifications or just failed notifications.

Namespace: Microsoft.SqlServer.Management.Nmo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntax

'Declaration
Public Property LogNotificationText As Boolean

public bool LogNotificationText { get; set; }

public:
property bool LogNotificationText {
    bool get ();
    void set (bool value);
}

/** @property */
public boolean get_LogNotificationText ()

/** @property */
public void set_LogNotificationText (boolean value)

public function get LogNotificationText () : boolean

public function set LogNotificationText (value : boolean)

Property Value

true if Notification Services logs all notification text; false if Notification Services logs notification text only for failed notifications.

Remarks

Updated text:5 December 2005

If you use the Application(Instance,String) constructor, the default value is true. If you use the default constructor, you must set this property.

The logged notification text is from the delivery protocol, which includes all notification text plus header text. The logged text is truncated at 2048 Unicode characters.

Notification logging has a negative impact on application performance because Notification Services logs information one notification at a time. Unless you use notification log data for all notifications, set this value to false. Notification Services still logs notification text and status for failed notifications.

To view log data, use the NS<NotificationClassName>NotificationDistribution View.

Example

The following examples show how to set all application execution settings, including logging behavior:

// Define application execution settings
myApplication.QuantumDuration = new TimeSpan(0, 0, 15);
myApplication.PerformanceQueryInterval = new TimeSpan(0, 0, 5);
myApplication.SubscriptionQuantumLimit = 1;
myApplication.ChronicleQuantumLimit = 1;
myApplication.VacuumRetentionAge = new TimeSpan(0, 0, 1);
myApplication.LogBeforeDeliveryAttempts = false;
myApplication.LogNotificationText = false;
myApplication.LogStatusInfo = false;
myApplication.EventThrottle = 500;
myApplication.NotificationThrottle = 500;
myApplication.SubscriptionThrottle = 500;
myApplication.ProcessEventsInOrder = false;

' Define application execution settings
myApplication.QuantumDuration = New TimeSpan(0, 0, 15)
myApplication.PerformanceQueryInterval = New TimeSpan(0, 0, 5)
myApplication.SubscriptionQuantumLimit = 1
myApplication.ChronicleQuantumLimit = 1
myApplication.VacuumRetentionAge = New TimeSpan(0, 0, 1)
myApplication.LogBeforeDeliveryAttempts = False
myApplication.LogNotificationText = False
myApplication.LogStatusInfo = False
myApplication.EventThrottle = 500
myApplication.NotificationThrottle = 500
myApplication.SubscriptionThrottle = 500
myApplication.ProcessEventsInOrder = False

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

Application Class
Application Members
Microsoft.SqlServer.Management.Nmo Namespace
LogStatusInfo
Application.LogBeforeDeliveryAttempts Property

Other Resources

Configuring Distributor Logging
LogNotificationText Element (ADF)