Share via

  • Article

Database.SnapshotIsolationState Property

Gets the snapshot isolation state for the database.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
<SfcPropertyAttribute> _
Public ReadOnly Property SnapshotIsolationState As SnapshotIsolationState
    Get
'Usage
Dim instance As Database
Dim value As SnapshotIsolationState

value = instance.SnapshotIsolationState

[SfcPropertyAttribute]
public SnapshotIsolationState SnapshotIsolationState { get; }

[SfcPropertyAttribute]
public:
property SnapshotIsolationState SnapshotIsolationState {
    SnapshotIsolationState get ();
}

[<SfcPropertyAttribute>]
member SnapshotIsolationState : SnapshotIsolationState

function get SnapshotIsolationState () : SnapshotIsolationState

Property Value

Type: Microsoft.SqlServer.Management.Smo.SnapshotIsolationState
A SnapshotIsolationState object value that specifies the snapshot isolation state of the database.

Remarks

Snapshot isolation (or row-level versioning) is an isolation level in SQL Server.

This property was introduced in SQL Server 2005.