DatabaseSnapshotIsolationState Enumeration
Namespace: Microsoft.TeamFoundation.Framework.Server
Assembly: Microsoft.TeamFoundation.Framework.Server (in Microsoft.TeamFoundation.Framework.Server.dll)
Syntax
'Declaration
Public Enumeration DatabaseSnapshotIsolationState
public enum DatabaseSnapshotIsolationState
public enum class DatabaseSnapshotIsolationState
type DatabaseSnapshotIsolationState
public enum DatabaseSnapshotIsolationState
Members
| Member name | Description | |
|---|---|---|
| InTransitionToOff | Snapshot isolation state is in transition to OFF state. All transactions have their modifications versioned. Cannot start new transactions using snapshot isolation. The database remains in the transition to OFF state until all transactions that were active when ALTER DATABASE was run can be completed. | |
| InTransitionToOn | Snapshot isolation state is in transition to ON state. New transactions have their modifications versioned. Transactions cannot use snapshot isolation until the snapshot isolation state becomes 1 (ON). The database remains in the transition to ON state until all update transactions that were active when ALTER DATABASE was run can be completed. | |
| Off | Snapshot isolation state is OFF (default). Snapshot isolation is disallowed. | |
| On | Snapshot isolation state is ON. Snapshot isolation is allowed. |