SnapshotIsolationState Enumeración

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

Espacio de nombres: Microsoft.SqlServer.Management.Smo
Ensamblado: Microsoft.SqlServer.SqlEnum (en Microsoft.SqlServer.SqlEnum.dll)

Sintaxis

'Declaración
Public Enumeration SnapshotIsolationState
'Uso
Dim instance As SnapshotIsolationState

public enum SnapshotIsolationState

public enum class SnapshotIsolationState

type SnapshotIsolationState

public enum SnapshotIsolationState

	Nombre del miembro	Descripción
	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.

The SnapshotIsolationState enumeration class is served by the SnapshotIsolationState property.