SQL Server: Error – ‘The operation ‘AUTO_CLOSE’ is not supported with databases that have a MEMORY_OPTIMIZED_DATA filegroup’

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: