Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
ChangeTrackingAutoCleanUp Property
Collapse the table of content
Expand the table of content

Database.ChangeTrackingAutoCleanUp Property

Gets or sets a 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)

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.Deploy)]
public bool ChangeTrackingAutoCleanUp { get; set; }

Property Value

Type: Boolean
A Boolean value that specifies whether change tracking information is automatically removed after the specified retention period. Enabling ChangeTrackingAutoCleanUp resets any previous custom retention period to the default retention period of 2 days.

Implements

IDatabaseOptions.ChangeTrackingAutoCleanUp

Community Additions

ADD
Show:
© 2015 Microsoft