CREATE PARTITION FUNCTION myRangePF1 (date)
AS RANGE LEFT FOR VALUES ('2007-01-01', '2008-01-01');
GO
CREATE PARTITION SCHEME myRangePS1
AS PARTITION myRangePF1
TO (test1fg, test2fg, test3fg) ;
GOCREATE TABLE [sx_test].[AmRate](
[amid] [int] NOT NULL,
[date] [datetime] NOT NULL,
[Amount] [decimal](18, 4) NULL,
[RateAmount] [decimal](18, 4) NULL,
CONSTRAINT [PK_AmRate_1] PRIMARY KEY CLUSTERED
(
[amid] ASC,
[date] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON myRangePS1([date])
) ON myRangePS1([date])
AS RANGE LEFT FOR VALUES ('2007-01-01', '2008-01-01');
GO
CREATE PARTITION SCHEME myRangePS1
AS PARTITION myRangePF1
TO (test1fg, test2fg, test3fg) ;
GOCREATE TABLE [sx_test].[AmRate](
[amid] [int] NOT NULL,
[date] [datetime] NOT NULL,
[Amount] [decimal](18, 4) NULL,
[RateAmount] [decimal](18, 4) NULL,
CONSTRAINT [PK_AmRate_1] PRIMARY KEY CLUSTERED
(
[amid] ASC,
[date] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON myRangePS1([date])
) ON myRangePS1([date])
CREATE PARTITION FUNCTION myRangePF1 (date)
AS RANGE LEFT FOR VALUES ('2007-01-01', '2008-01-01');
GO
这条语句运行后报错,消息 7736,级别 16,状态 1,第 2 行
Partition function can only be created in Enterprise edition of SQL Server. Only Enterprise edition of SQL Server supports partitioning.什么原因?跟我的权限有关吗?
请高手指教.
CREATE PARTITION FUNCTION myRangePF1 (date)
AS RANGE LEFT FOR VALUES ('2007-01-01', '2008-01-01');
GO
这条语句运行后报错,消息 7736,级别 16,状态 1,第 2 行
Partition function can only be created in Enterprise edition of SQL Server. Only Enterprise edition of SQL Server supports partitioning. 什么原因?跟我的权限有关吗?
请高手指教.