SELECT * FROM dbo.ShoppingCart (non_existing_hint) WHERE ShoppingCartId = 1;
A system assertion check has failed. Check the SQL Server error log for details. Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB. If you agreed to send dumps to Microsoft during setup, a mini dump will be sent to Microsoft. An update might be available from Microsoft in the latest Service Pack or in a Hotfix from Technical Support.
After you install the update, SQL Server doesn't crash in this scenario, and you receive an error message that looks something like:
The table option 'xxxxx' is not supported with memory optimized tables.
Article ID: 3138775 - Last Review: Apr 18, 2016 - Revision: 1