帮我看看这个建表语句
CREATE   TABLE   [dbo].[SysRole_In_Site](
[Id]   [int]   IDENTITY(1,1)   NOT   NULL,
[RoleId]   [int]   NOT   NULL,
[Site]   [varchar](50)   NOT   NULL,
  CONSTRAINT   [PK_SysRoleInSite]   PRIMARY   KEY   CLUSTERED  
(
[Id]   ASC
)WITH   (IGNORE_DUP_KEY   =   OFF)   ON   [PRIMARY],
  CONSTRAINT   [IX_SysRole_In_Site]   UNIQUE   NONCLUSTERED  
(
[RoleId]   ASC,
[Site]   ASC
)WITH   (IGNORE_DUP_KEY   =   OFF)   ON   [PRIMARY]
)   ON   [PRIMARY]
怎么在sql   server   2000查询分析器中通不过，有什么错误

------解决方案--------------------
CREATE TABLE [dbo].[SysRole_In_Site](
[Id] [int] IDENTITY(1,1) NOT NULL,
[RoleId] [int] NOT NULL,
[Site] [varchar](50) NOT NULL,
CONSTRAINT [PK_SysRoleInSite] PRIMARY KEY CLUSTERED
(
[Id] ASC
) ON [PRIMARY],
CONSTRAINT [IX_SysRole_In_Site] UNIQUE NONCLUSTERED
(
[RoleId] ASC,
[Site] ASC
) ON [PRIMARY]
) ON [PRIMARY]
------解决方案--------------------
你的是在2005中导出的语法吧！2000下不认 WITH 语句