大家好今天在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
不知道如何解决
看看你的数据库版本,2014(12.x)以上才可以用 CONTAINS MEMORY_OPTIMIZED_DATA