Any suggestions? Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

SnapshotIsolationState Enumeration

 

The SnapshotIsolationState enumeration contains values that are used to specify the current state of snapshot isolation.

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.SqlEnum (in Microsoft.SqlServer.SqlEnum.dll)

public enum SnapshotIsolationState

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

The SnapshotIsolationState enumeration class is served by the SnapshotIsolationState property.

Return to top
Show:
© 2016 Microsoft