BlogEngine使用SQL Server 2000做後台資料庫

在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 2005CREATE 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 2000CREATE 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

http://www.cnblogs.com/dugoogle/archive/2007/11/10/955078.html

http://www.codeplex.com/blogengine/Thread/View.aspx?ThreadId=12814

http://www.codeplex.com/blogengine/Thread/View.aspx?ThreadId=17608