SYSTEM_VERSIONING is not turned on for a table in a database that has the READ_COMMITTED_SNAPSHOT isolation level enabled in SQL Server 2016

Symptoms
You try to turn on SYSTEM_VERSIONING for a memory-optimized table in a database that has the READ_COMMITTED_SNAPSHOT isolation level enabled. If the DATA_CONSISTENCY_CHECK is not disabled, you may receive an error message that resembles the following:
Msg 41359, Level 16, State 0, Line 36A 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).

Resolution
The fix for this issue is included in the following cumulative update for SQL Server:


About cumulative updates for SQL Server
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:

Workaround
To work around this issue, turn off the data consistency check by adding the DATA_CONSISTENCY_CHECK = OFF clause in your CREATE TABLE statement.
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
References
Learn about the terminology Microsoft uses to describe software updates.
Properties

Article ID: 3174711 - Last Review: 07/25/2016 22:25:00 - Revision: 1.0

Microsoft SQL Server 2016 Developer, Microsoft SQL Server 2016 Enterprise, Microsoft SQL Server 2016 Enterprise Core

  • kbqfe kbfix kbexpertiseinter kbsurveynew KB3174711
Feedback