Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Gets or sets the amount of history logged during agent execution.
Namespace: Microsoft.SqlServer.Replication
Assembly: Microsoft.SqlServer.Replication (in Microsoft.SqlServer.Replication.dll)
Syntax
'Declaration
Public Property HistoryVerboseLevel As Integer
Get
Set
'Usage
Dim instance As AgentCore
Dim value As Integer
value = instance.HistoryVerboseLevel
instance.HistoryVerboseLevel = value
public int HistoryVerboseLevel { get; set; }
public:
property int HistoryVerboseLevel {
int get ();
void set (int value);
}
member HistoryVerboseLevel : int with get, set
function get HistoryVerboseLevel () : int
function set HistoryVerboseLevel (value : int)
Property Value
Type: System.Int32
An Int32 value that can be one of the following:
Value |
Description |
|---|---|
1 |
Always update a previous history message of the same status (startup, progress, success, and so on). If no previous record with the same status exists, insert a new record. |
2 (default) |
Insert new history records unless the record is for such things as idle messages or long-running job messages, in which case update the previous records. |
3 |
Always insert new records, unless it is for idle messages. |
Remarks
You can minimize the effect of history logging on performance by specifying a value of 1 for HistoryVerboseLevel.