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).