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. |