I found blogengine on www.asp.net and thought it was quite suitable for me to study. So I downloaded it and found that he used SQL Server 2005, but I only had SQL Server 2000, however, the SQL installation script provided by him may encounter errors in SQL Server 2000, as shown below:
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 _ setting '.
The tables that contain (max) are:
Be_pages
Be_postcomment
Be_posts
Be_settings
It should be caused by different databases. Later, I found a solution on the forum,
1. Remove all
With (ignore DUP Key = OFF) on [primary]
2. Replace [varchar] (max) with ntext
The following is a comparison between sql2005 and SQL2000 scripts:
-- 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
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