错误信息:
[42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]联机索引操作只能在 SQL Server Enterprise Edition 中执行。 (1712)
创建索引语句:
CREATE NONCLUSTERED INDEX [Bill_BCopied_NIX] ON [dbo].[bill] (BCopied ASC) WITH (ONLINE = ON)
解决方法:
提示已经很明确了,方法有二种:
1,升级成企业版SQL
2,删除语句: WITH (ONLINE = ON) 改为:
CREATE NONCLUSTERED INDEX [Bill_BCopied_NIX] ON [dbo].[bill] (BCopied ASC) WITH (ONLINE = ON)