Enumeración SnapshotIsolationState
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
Miembros
| 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. |
Comentarios
The SnapshotIsolationState enumeration class is served by the SnapshotIsolationState property.