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)
Syntax
'Bildirim
Public Enumeration SnapshotIsolationState
public enum SnapshotIsolationState
public enum class SnapshotIsolationState
public enum SnapshotIsolationState
public enum SnapshotIsolationState
Members
| Member name | Description |
|---|---|
| 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. |
Remarks
The SnapshotIsolationState enumeration class is served by the SnapshotIsolationState property.
Platforms
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.
Target Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.