在www.asp.net上找到了BlogEngine,觉得还比较适合我学习研究,于是下载下来,结果发现他用的是SQL Server 2005,可我只有SQL Server 2000,但他提供的SQL installation script在SQL Server 2000中运行会出现错误,如下:
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.azimat.net/detil.asp?titenan=36