Share via

  • Article

IDatabaseOptions.ChangeTrackingRetentionPeriodUnits Property

Specifies the units for the change tracking retention period.

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

Syntax

'Declaration
<DisplayNameKeyAttribute("Database_ChangeTrackingRetentionPeriodUnitsName")> _
<DisplayDescriptionKeyAttribute("Database_ChangeTrackingRetentionPeriodUnitsDesc")> _
Property ChangeTrackingRetentionPeriodUnits As RetentionPeriodUnits
    Get
    Set
'Usage
Dim instance As IDatabaseOptions
Dim value As RetentionPeriodUnits

value = instance.ChangeTrackingRetentionPeriodUnits

instance.ChangeTrackingRetentionPeriodUnits = value

[DisplayNameKeyAttribute("Database_ChangeTrackingRetentionPeriodUnitsName")]
[DisplayDescriptionKeyAttribute("Database_ChangeTrackingRetentionPeriodUnitsDesc")]
RetentionPeriodUnits ChangeTrackingRetentionPeriodUnits { get; set; }

[DisplayNameKeyAttribute(L"Database_ChangeTrackingRetentionPeriodUnitsName")]
[DisplayDescriptionKeyAttribute(L"Database_ChangeTrackingRetentionPeriodUnitsDesc")]
property RetentionPeriodUnits ChangeTrackingRetentionPeriodUnits {
    RetentionPeriodUnits get ();
    void set (RetentionPeriodUnits value);
}

[<DisplayNameKeyAttribute("Database_ChangeTrackingRetentionPeriodUnitsName")>]
[<DisplayDescriptionKeyAttribute("Database_ChangeTrackingRetentionPeriodUnitsDesc")>]
abstract ChangeTrackingRetentionPeriodUnits : RetentionPeriodUnits with get, set

function get ChangeTrackingRetentionPeriodUnits () : RetentionPeriodUnits
function set ChangeTrackingRetentionPeriodUnits (value : RetentionPeriodUnits)

Property Value

Type: Microsoft.SqlServer.Management.Smo.RetentionPeriodUnits
A RetentionPeriodUnits type that specifies the units for the retention period value.

Remarks

You can select Minutes, Hours, Days, Weeks, Months or Years. The default value is Days. The minimum retention period is 1 minute. There is no maximum retention period.