Enumerazione SnapshotIsolationState

The SnapshotIsolationState enumeration contains values that are used to specify the current state of snapshot isolation.

Spazio dei nomi  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.SqlEnum (in Microsoft.SqlServer.SqlEnum.dll)

Sintassi

'Dichiarazione
Public Enumeration SnapshotIsolationState
'Utilizzo
Dim instance As SnapshotIsolationState
public enum SnapshotIsolationState
public enum class SnapshotIsolationState
type SnapshotIsolationState
public enum SnapshotIsolationState

Membri

Nome membro Descrizione
Disabled Snapshot isolation is not currently in effect.
Enabled Snapshot isolation is in effect. If the transaction isolation level is set to snapshot then the versions of updates to a record are stored in the tempdb database.
PendingOff Snapshot isolation is waiting to be disabled when all current transactions commit or roll back.
PendingOn Snapshot isolation is waiting to be enabled when all current transactions commit or roll back.

Osservazioni

The SnapshotIsolationState enumeration class is served by the SnapshotIsolationState property.