This documentation is archived and is not being maintained.

DatabaseSnapshotIsolationState Enumeration

Namespace:  Microsoft.TeamFoundation.Framework.Server
Assembly:  Microsoft.TeamFoundation.Framework.Server (in Microsoft.TeamFoundation.Framework.Server.dll)

public enum class DatabaseSnapshotIsolationState

Member nameDescription
InTransitionToOffSnapshot 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.

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

OffSnapshot isolation state is OFF (default). Snapshot isolation is disallowed.

OnSnapshot isolation state is ON. Snapshot isolation is allowed.

Show: