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.)

See Also

Reference

IDatabaseOptions Interface

Microsoft.SqlServer.Management.Smo Namespace