Breaking News: Grepper is joining You.com. Read the official announcement!

Cannot create memory optimized tables. To create memory optimized tables, the database must have a MEMORY_OPTIMIZED_FILEGROUP that is online and has at least one container.

Fortune Mbulazi answered on October 5, 2022 Popularity 3/10 Helpfulness 2/10

answer Cannot create memory optimized tables. To create memory optimized tables, the database must have a MEMORY_OPTIMIZED_FILEGROUP that is online and has at least one container.

Cannot create memory optimized tables. To create memory optimized tables, the database must have a MEMORY_OPTIMIZED_FILEGROUP that is online and has at least one container.

Comment

//you must create a file Group first :
ALTER DATABASE imoltp ADD FILEGROUP imoltp_mod CONTAINS MEMORY_OPTIMIZED_DATA;

//Add DatabaseFile To Your File Group :
ALTER DATABASE imoltp ADD FILE (name='imoltp_mod1', filename='c:\data\imoltp_mod1')
TO FILEGROUP imoltp_mod;

//Create Memory Optimize Table:
CREATE TABLE dbo.Account
(   
	AccountID INT IDENTITY(1,1) PRIMARY KEY NONCLUSTERED
)WITH(MEMORY_OPTIMIZED=ON)

Popularity 3/10 Helpfulness 2/10 Language sql

Source: www.youtube.com

Tags: database sql

Link to this answer
Share Copy Link

Contributed on Oct 05 2022

Fortune Mbulazi

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Cannot create memory optimized tables. To create memory optimized tables, the database must have a MEMORY_OPTIMIZED_FILEGROUP that is online and has at least one container.

Contents

More Related Answers

Cannot create memory optimized tables. To create memory optimized tables, the database must have a MEMORY_OPTIMIZED_FILEGROUP that is online and has at least one container.

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.