MSSQLSERVER_41359

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Details

Product Name

SQL Server

Event ID

41359

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic Name

SQL_READ_COMMITTED_SNAPSHOT_NOT_SUPPORTED

Message Text

A query that accesses memory optimized tables using the READ COMMITTED isolation level, cannot access disk based tables when the database option READ_COMMITTED_SNAPSHOT is set to ON. Provide a supported isolation level for the memory optimized table using a table hint, such as WITH (SNAPSHOT).

Explanation

The database with READ_COMMITTED_SNAPSHOT=ON does not support the transactions that access both memory-optimized tables and disk based tables.

User Action

Set READ_COMMITTED_SNAPSHOT to OFF or supply a supported isolation level for the memory-optimized table using a table-level hint, such as WITH (SNAPSHOT). For more information, see In-Memory OLTP (In-Memory Optimization).

See Also

Concepts

In-Memory OLTP (In-Memory Optimization)