SQL Server Error Msg 8700 – Query could not run because column store indexes on memory optimized tables are currently disabled.  Rewrite the query with an index hint specifying a different index.

In this blog post, let’s learn about the error message “8700 – Query could not run because column store indexes on memory optimized tables are currently disabled.  Rewrite the query with an index hint specifying a different index.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

8700 – Query could not run because column store indexes on memory optimized tables are currently disabled.  Rewrite the query with an index hint specifying a different index.

Reason for the Error

To be update soon…

Solution

To be update soon…