Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

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
public enum SnapshotIsolationState
public enum SnapshotIsolationState
Member nameDescription
DisabledSnapshot isolation is not currently in effect.
EnabledSnapshot 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.
PendingOffSnapshot isolation is waiting to be disabled when all current transactions commit or roll back.
PendingOnSnapshot isolation is waiting to be enabled when all current transactions commit or roll back.

The SnapshotIsolationState enumeration class is served by the SnapshotIsolationState property.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.


Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.