In this blog post, let’s learn about the error message “41359 – 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).” in Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
41359 – 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).
Reason for the Error
To be update soon…
Solution
To be update soon…