最近想做个blog,可是从头开始又太麻烦,最好决定找一个源码来修改,于是在www.asp.net上找到了BlogEngine,觉得还比较适合我学习研究,于是下载下来,结果发现他用的是SQL2005,可我只有SQL2000,但他提供的SQL installation script在SQL2000中运行会出现错误,如下:

Server: Msg 170, Level 15, State 1, Line 7
Line 7: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near 'max'.
Server: Msg 170, Level 15, State 1, Line 7
Line 7: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near 'max'.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near 'max'.
Server: Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near 'max'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'be_Settings'.

The tables that contain (max) are:
be_Pages
be_PostComment
be_Posts
be_Settings

应该是应为数据库不同而造成的,后来在论坛上找到了解决方法,
1.去除 SQL installation script中所有的
WITH (IGNOREDUPKEY = OFF) ON [PRIMARY]
2.将[varchar](max) 用ntext替换

以下是SQL2005与SQL2000中script的不同比较:
--SQL 2005
CREATE TABLE [dbo].[Table1]
(
[Field1] [int] IDENTITY(1,1) NOT NULL,
[Field2] [varchar(max)] NULL,
CONSTRAINT [PK_Table1] PRIMARY KEY CLUSTERED
(
[Field1] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]


--SQL 2000
CREATE TABLE [dbo].[Table1]
(
[Field1] [int] IDENTITY(1,1) NOT NULL,
[Field2] [ntext] NULL,
CONSTRAINT [PK_Table1] PRIMARY KEY CLUSTERED
(
[Field1] ASC
)WITH IGNORE_DUP_KEY = OFF
) ON [PRIMARY]


这是原文地址:
http://www.codeplex.com/blogengine/Thread/View.aspx?ThreadId=12814
http://www.codeplex.com/blogengine/Thread/View.aspx?ThreadId=17608