This article is half-done without your Comment! *** Please share your thoughts via Comment ***
If you don’t about the option AUTO_CLOSE, please visit the previous post.
‘The operation ‘AUTO_CLOSE’ is not supported with databases that have a MEMORY_OPTIMIZED_DATA filegroup’ You are getting this error because your database set to AUTO_CLOSE ON that’s why you were unable to create a memory-optimized file group or data file.
If you are planning to use In-Memory OLTP tables, you must set to AUTO_CLOSE OFF.
Using SSMS, Set Auto Close OFF:
|
1 |
Right-click on database -> Properties -> Options -> Automatice Section -> Auto Close |
|
1 2 3 4 |
USE [master] GO ALTER DATABASE [DatabaseName] SET AUTO_CLOSE OFF; GO |
