SnapshotIsolationState 枚举
The SnapshotIsolationState enumeration contains values that are used to specify the current state of snapshot isolation.
命名空间: Microsoft.SqlServer.Management.Smo
程序集: Microsoft.SqlServer.SqlEnum(在 Microsoft.SqlServer.SqlEnum.dll 中)
语法
声明
Public Enumeration SnapshotIsolationState
用法
Dim instance As SnapshotIsolationState
public enum SnapshotIsolationState
public enum class SnapshotIsolationState
type SnapshotIsolationState
public enum SnapshotIsolationState
成员
成员名称 | 说明 | |
---|---|---|
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. |