db script error

Topics: Business Logic Layer
Jul 25, 2008 at 10:56 AM
Hi

i'm attempting to setup my blog using sql server however i'm receiving an error from the setup script. I've tried both sql server 2000 and 2005 express. the error is the same for both:

Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near '('.
Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near 'max'.
Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near 'max'.
Msg 170, Level 15, State 1, Line 7
Line 7: Incorrect syntax near '('.
Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near 'max'.
Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near 'max'.
Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near 'max'.
Msg 170, Level 15, State 1, Line 6
Line 6: Incorrect syntax near '('.
Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near '('.
Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near 'max'.
Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near '('.
Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near '('.
Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near '('.
Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near '('.
Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near '('.
Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near '('.
Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near '('.
Msg 170, Level 15, State 1, Line 6
Line 6: Incorrect syntax near '('.
Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near '('.


thanks and regards
Sean

Jul 28, 2008 at 10:44 AM
to answer my own question, the db script is for sql server 2005. it will not work (without amending it) with sql server 2000.
Jul 28, 2008 at 12:56 PM
this link shows how to amend the setup script to execute in sql server 2000.

http://www.azimat.net/detil.asp?titenan=36


Jul 28, 2008 at 10:27 PM
Are you running it on some web-interface or SQL Management Studio (2005)?
Jul 29, 2008 at 8:32 AM
The error above was from Enterprise Manager (2000) and SQL Management Studio Express (2005).