Unable to issue alter table for a memory optimized tables
First published on MSDN on May 10, 2017 Recently I assisted on a customer issue where customer wasn’t able to alter a memory optimized table with the following error Msg 41317, Level 16, State 3, Procedure ddl, Line 4 [Batch Start Line 35]A user transaction that accesses memory optimized tables or natively compiled modules cannot access more than one user database or databases model and msdb, and it cannot write to master.Solve your tempdb problems with memory optimized tables
First published on MSDN on Mar 25, 2016 if you are on SQL Server 2014 and above and have tempdb problems, SQL Server In-Memory OLTP Program Manager Jos de Bruijn just posted a great blog titled “Improving temp table and table variable performance using memory optimization”.
