Partilhar via


DataSourceIsolation Enumeration

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

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

Syntax

'Declaration
Public Enumeration DataSourceIsolation
public enum DataSourceIsolation
public enum class DataSourceIsolation
public enum DataSourceIsolation
public enum DataSourceIsolation

Members

Member name Description
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.

Remarks

New:17 July 2006

Snapshot is data source dependant.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

Microsoft.AnalysisServices Namespace