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)

[<SfcPropertyAttribute(SfcPropertyFlags.None | SfcPropertyFlags.Standalone | SfcPropertyFlags.SqlAzureDatabase | SfcPropertyFlags.Deploy)>]
abstract ChangeTrackingRetentionPeriod : int with get, set
[<SfcPropertyAttribute(SfcPropertyFlags.None | SfcPropertyFlags.Standalone | SfcPropertyFlags.SqlAzureDatabase | SfcPropertyFlags.Deploy)>]
override ChangeTrackingRetentionPeriod : int with get, set

Property Value

Type: System.Int32

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

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.

Return to top
Show: