求用过azure sql的大神帮忙解答下

[dota_sky_god]

数据库表的生成脚本如下：

USE [TEST]
GO
/****** Object:  Table [dbo].[tbl_monster]    Script Date: 07/08/2014 15:30:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tbl_monster](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[land_id] [int] NOT NULL,
	[name] [nvarchar](50) NULL,
	[blood] [int] NULL,
	[bloodadd] [int] NULL,
	[attack] [int] NULL,
	[attackadd] [int] NULL,
	[exp] [int] NULL,
	[expadd] [int] NULL,
 CONSTRAINT [PK_tbl_monster] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[tbl_land]    Script Date: 07/08/2014 15:30:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tbl_land](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[landEName] [nvarchar](50) NULL,
	[landCName] [nvarchar](50) NULL,
 CONSTRAINT [PK_tbl_land] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[tbl_item]    Script Date: 07/08/2014 15:30:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tbl_item](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[item_name] [nvarchar](50) NULL,
	[item_type] [nvarchar](50) NULL,
	[item_description] [nvarchar](50) NULL,
 CONSTRAINT [PK_tbl_item] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

在本地数据库上运行是没问题的，可是在azure下就出现这样的问题，这应该怎么解决？

消息 40514，级别 16，状态 1，行 9
'Filegroup reference and partitioning scheme' is not supported in this version of SQL Server.
消息 40514，级别 16，状态 1，行 30
'Filegroup reference and partitioning scheme' is not supported in this version of SQL Server.
消息 40514，级别 16，状态 1，行 45
'Filegroup reference and partitioning scheme' is not supported in this version of SQL Server.

[csdn_aspnet]

版本不支持 你本地和服务器数据库版本可否一样

[dota_sky_god]

引用 1 楼 hefeng_aspnet 的回复:

版本不支持 你本地和服务器数据库版本可否一样

我的版本是SQL SERVER2008 R2 服务器的怎么看？因为刚接触云服务器，不是很清楚的说

[geyewei]

把这些代码去掉，就可以执行了吧。 WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

[our2848884]

同意楼上的意见。你可以看看这篇文章。 http://blog.ehuna.org/2009/08/cleaning_up_scripts_for_sql_az.html