Isolation Element (ASSL)


Applies To: SQL Server 2016 Preview

Indicates the isolation level for an element that is derived from the DataSource data type.


Data type and lengthString (enumeration)
Default valueReadCommitted
Cardinality0-1: Optional element that can occur once and only once.
Parent elementDataSource
Child elementsNone

The value for this element is limited to one of the strings in the following table.

ReadCommittedSpecifies that statements cannot read data that has been modified but not committed by other transactions. This prevents dirty reads. Other transactions can change data between individual statements within the current transaction. This results in nonrepeatable reads or phantom data. This value is the default for the Isolation element.
SnapshotSpecifies that the data that is read by any statement in a transaction will be the transactionally consistent version of the data that existed at the start of the transaction. The transaction can only see data modifications that were committed before the start of the transaction. Data modifications that are made by other transactions after the start of the current transaction are not visible to statements that are executing in the current transaction. The effect is as if the statements in a transaction get a snapshot of the committed data as it existed at the start of the transaction.

Properties (ASSL)

Community Additions