Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
MSDN Library

DataSourceIsolation Enumeration

 

Applies To: SQL Server 2016 Preview

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

Community Additions

Show:
© 2015 Microsoft