IDatabaseOptions.IsReadCommittedSnapshotOn Property
Gets a value that specifies whether transactions with the read committed isolation level use row versioning.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
<DisplayDescriptionKeyAttribute("Database_IsReadCommittedSnapshotOnDesc")> _
<DisplayNameKeyAttribute("Database_IsReadCommittedSnapshotOnName")> _
Property IsReadCommittedSnapshotOn As Boolean
Get
Set
'Usage
Dim instance As IDatabaseOptions
Dim value As Boolean
value = instance.IsReadCommittedSnapshotOn
instance.IsReadCommittedSnapshotOn = value
[DisplayDescriptionKeyAttribute("Database_IsReadCommittedSnapshotOnDesc")]
[DisplayNameKeyAttribute("Database_IsReadCommittedSnapshotOnName")]
bool IsReadCommittedSnapshotOn { get; set; }
[DisplayDescriptionKeyAttribute(L"Database_IsReadCommittedSnapshotOnDesc")]
[DisplayNameKeyAttribute(L"Database_IsReadCommittedSnapshotOnName")]
property bool IsReadCommittedSnapshotOn {
bool get ();
void set (bool value);
}
[<DisplayDescriptionKeyAttribute("Database_IsReadCommittedSnapshotOnDesc")>]
[<DisplayNameKeyAttribute("Database_IsReadCommittedSnapshotOnName")>]
abstract IsReadCommittedSnapshotOn : bool with get, set
function get IsReadCommittedSnapshotOn () : boolean
function set IsReadCommittedSnapshotOn (value : boolean)
Property Value
Type: System.Boolean
A Boolean value that indicates whether transactions with the read committed isolation level use row versioning.If True, the transactions use row versioning. Otherwise, False (default.)