IDatabaseOptions.ChangeTrackingAutoCleanUp Property

Gets or sets a Boolean property value that specifies whether the CHANGE_TRACKING_AUTO_CLEANUP OPTION is enabled.

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

Syntax

'Declaration
<DisplayNameKeyAttribute("Database_ChangeTrackingAutoCleanUpName")> _
<DisplayDescriptionKeyAttribute("Database_ChangeTrackingAutoCleanUpDesc")> _
Property ChangeTrackingAutoCleanUp As Boolean 
    Get 
    Set
'Usage
Dim instance As IDatabaseOptions 
Dim value As Boolean 

value = instance.ChangeTrackingAutoCleanUp

instance.ChangeTrackingAutoCleanUp = value

[DisplayNameKeyAttribute("Database_ChangeTrackingAutoCleanUpName")]
[DisplayDescriptionKeyAttribute("Database_ChangeTrackingAutoCleanUpDesc")]
bool ChangeTrackingAutoCleanUp { get; set; }

[DisplayNameKeyAttribute(L"Database_ChangeTrackingAutoCleanUpName")]
[DisplayDescriptionKeyAttribute(L"Database_ChangeTrackingAutoCleanUpDesc")]
property bool ChangeTrackingAutoCleanUp {
    bool get ();
    void set (bool value);
}

[<DisplayNameKeyAttribute("Database_ChangeTrackingAutoCleanUpName")>]
[<DisplayDescriptionKeyAttribute("Database_ChangeTrackingAutoCleanUpDesc")>]
abstract ChangeTrackingAutoCleanUp : bool with get, set

function get ChangeTrackingAutoCleanUp () : boolean 
function set ChangeTrackingAutoCleanUp (value : boolean)

Property Value

Type: System.Boolean
A Boolean value that specifies whether change tracking information is automatically removed.If True, change tracking information is automatically removed after a configurable retention period.If False (default), change tracking information is not automatically removed.

Remarks

The change tracking retention period can be configured with the ChangeTrackingRetentionPeriod property.

See Also

Reference

IDatabaseOptions Interface

Microsoft.SqlServer.Management.Smo Namespace