Error When Executing MSSQLSetup Against Database

Topics: Business Logic Layer
Jan 5, 2008 at 5:12 AM
I'm fairly new with using MSSQL (Using SQL Server 2000). I executed the MSSQLSetup in the Query Analyzer. As a result, I got the error below. Moreover, I'm not sure why or what it means. Thank you in advance for any assitance you can provide.

Server: Msg 170, Level 15, State 1, Line 8
Line 8: 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 4
Line 4: Incorrect syntax near 'max'.
Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near 'max'.
Server: Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near '('.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.be_PostCategory' because this table does not exist in database 'MidnightLamp'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.be_PostCategory' because this table does not exist in database 'MidnightLamp'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.be_PostCategory' because this table does not exist in database 'MidnightLamp'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.be_PostCategory' because this table does not exist in database 'MidnightLamp'.
Server: Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near 'max'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.be_PostComment' because this table does not exist in database 'MidnightLamp'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.be_PostComment' because this table does not exist in database 'MidnightLamp'.
Server: Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near '('.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.be_PostNotify' because this table does not exist in database 'MidnightLamp'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.be_PostNotify' because this table does not exist in database 'MidnightLamp'.
Server: Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near '('.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.be_PostTag' because this table does not exist in database 'MidnightLamp'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.be_PostTag' because this table does not exist in database 'MidnightLamp'.
Server: Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near '('.
Jan 5, 2008 at 7:01 AM
The SQL script in the setup directory is for SQL Server 2005. It doesn't work with SQL Server 2000. This has been a common source of confusion. Maybe someone can post their SQL Server 2000 version?