The enumeration contains values that are used to specify the current state of snapshot isolation.
Assembly: Microsoft.SqlServer.SqlEnum (in Microsoft.SqlServer.SqlEnum.dll)
|Snapshot isolation is not currently in effect.|
|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.|
|Snapshot isolation is waiting to be disabled when all current transactions commit or roll back.|
|Snapshot isolation is waiting to be enabled when all current transactions commit or roll back.|