Isolation Element (ASSL)

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



Element Characteristics

Characteristic Description

Data type and length

String (enumeration)

Default value



0-1: Optional element that can occur once and only once.

Element Relationships

Relationship Element

Parent element


Child elements



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

Value Description


Specifies 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.


Specifies 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.

See Also


Properties (ASSL)

Other Resources

Isolation Levels in the Database Engine

Help and Information

Getting SQL Server 2005 Assistance