SQL sever创建用户数据库失败

Question

大家好今天在SQL sever 创建用户数据库时遇到了一个没有解决的问题 大家能不能帮我看一看啊

-- =============================================
-- Create Database with MEMORY_OPTIMIZED_DATA Filegroup Template
-- =============================================

IF EXISTS (
  SELECT * 
    FROM sys.databases 
   WHERE name = N'sample_database'
)
  DROP DATABASE sample_database
GO

CREATE DATABASE sample_database
ON PRIMARY
  (NAME = sample_database_file1,
    FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Data\Datasample_database_1.mdf',
          SIZE = 10MB,
          MAXSIZE = 50MB,
          FILEGROWTH = 10%),

FILEGROUP sample_database_filegroup CONTAINS MEMORY_OPTIMIZED_DATA
  ( NAME = sample_database_filegroup_file1,
    FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Data\Datasample_database_1')

LOG ON
  ( NAME = sample_database_log_file1,
    FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Data\Datasample_database_1.ldf',
          SIZE = 10MB,
          MAXSIZE = 50MB,
          FILEGROWTH = 10%)
GO

消息 102，级别 15，状态 1，第 21 行
'CONTAINS' 附近有语法错误。

完成时间: 2023-03-20T19:38:26.5686456+08:00
不知道如何解决

Answer 1

看看你的数据库版本，2014（12.x）以上才可以用 CONTAINS MEMORY_OPTIMIZED_DATA