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
ReadCommitted

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

Snapshot

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
Show: