Database.ChangeTrackingEnabled Property
Gets or sets a value that specifies whether the CHANGE_TRACKING_VALUE option is enabled
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.Deploy)> _
Public Property ChangeTrackingEnabled As Boolean
Get
Set
'Usage
Dim instance As Database
Dim value As Boolean
value = instance.ChangeTrackingEnabled
instance.ChangeTrackingEnabled = value
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.Deploy)]
public bool ChangeTrackingEnabled { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::Deploy)]
public:
virtual property bool ChangeTrackingEnabled {
bool get () sealed;
void set (bool value) sealed;
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.Deploy)>]
abstract ChangeTrackingEnabled : bool with get, set
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.Deploy)>]
override ChangeTrackingEnabled : bool with get, set
final function get ChangeTrackingEnabled () : boolean
final function set ChangeTrackingEnabled (value : boolean)
Property Value
Type: System.Boolean
A Boolean value that specifies whether the change tracking information is saved.
Implements
IDatabaseOptions.ChangeTrackingEnabled
Remarks
Use to enable or disable change tracking for the database. To enable change tracking, you must have permission to modify the database. Setting ChangeTrackingEnabled to True sets a database option that allows change tracking to be enabled on individual tables.
See Also
Reference
Microsoft.SqlServer.Management.Smo Namespace