• Article

Database.ChangeTrackingRetentionPeriod Property

Gets or sets the CHANGE_TRACKING_RETENTION_PERIOD value.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
<SfcPropertyAttribute> _
Public Property ChangeTrackingRetentionPeriod As Integer
    Get
    Set
'Usage
Dim instance As Database
Dim value As Integer

value = instance.ChangeTrackingRetentionPeriod

instance.ChangeTrackingRetentionPeriod = value

[SfcPropertyAttribute]
public int ChangeTrackingRetentionPeriod { get; set; }

[SfcPropertyAttribute]
public:
virtual property int ChangeTrackingRetentionPeriod {
    int get () sealed;
    void set (int value) sealed;
}

[<SfcPropertyAttribute>]
abstract ChangeTrackingRetentionPeriod : int with get, set
[<SfcPropertyAttribute>]
override ChangeTrackingRetentionPeriod : int with get, set

final function get ChangeTrackingRetentionPeriod () : int
final function set ChangeTrackingRetentionPeriod (value : int)

Property Value

Type: System.Int32
A Int32 that specifies the minimum period to retain tracing information.

Implements

IDatabaseOptions.ChangeTrackingRetentionPeriod

Remarks

A ChangeTrackingRetentionPeriod Specifies the minimum period for keeping change track information in the database. Data is removed only if the Auto Clean-Up value is True.