DataSourceIsolation Enumeration


Updated: May 24, 2016

Controls the locking behavior of the SQL statements issued to a data source.

Namespace:   Microsoft.AnalysisServices
Assembly:  Microsoft.AnalysisServices (in Microsoft.AnalysisServices.dll)

public enum DataSourceIsolation

Member nameDescription

Specifies that statements cannot read data that has been modified, but not committed, by other transactions. This prevents dirty reads.


Specifies that the data read by any statement in a transaction is transactionally consistent, as if the statements in a transaction receive a snapshot of the committed data as it existed at the start of the transaction.

New: 17 July 2006

Snapshot is data source dependant.

Return to top