Cannot run SQL Scripts?

Topics: User Forum
Dec 28, 2006 at 7:42 PM
Trying to run the sql scripts as instructed, on a SQL 200 Standard install and a SQL 2000 Personal install, on two different servers.
I receive the following errors when tring to run schema.sql:

Server: Msg 170, Level 15, State 1, Line 10
Line 10: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 12
Line 12: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 14
Line 14: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 9
Line 9: Incorrect syntax near '('.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 170, Level 15, State 1, Line 13
Line 13: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 11
Line 11: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 21
Line 21: Incorrect syntax near '('.
Server: Msg 208, Level 16, State 4, Procedure AuditUpdateDT, Line 2
Invalid object name 'dbo.Monitor'.
Server: Msg 170, Level 15, State 1, Line 13
Line 13: 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 7
Line 7: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 6
Line 6: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 9
Line 9: Incorrect syntax near '('.
Server: Msg 208, Level 16, State 4, Procedure UpDownTimeCalculation, Line 8
Invalid object name 'dbo.MonitorEvent'.
Server: Msg 170, Level 15, State 1, Line 15
Line 15: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 13
Line 13: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 7
Line 7: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 14
Line 14: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 6
Line 6: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 10
Line 10: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 12
Line 12: Incorrect syntax near '('.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.foreign_keys'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.foreign_keys'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.foreign_keys'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.Monitor' because this table does not exist in database 'PolyMon'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.foreign_keys'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.MonitorEvent' because this table does not exist in database 'PolyMon'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.foreign_keys'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.MonitorEvent' because this table does not exist in database 'PolyMon'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.foreign_keys'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.MonitorAlertRule' because this table does not exist in database 'PolyMon'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.foreign_keys'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.MonitorEventCounter' because this table does not exist in database 'PolyMon'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.foreign_keys'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.MonitorEventCounter' because this table does not exist in database 'PolyMon'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.foreign_keys'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.MonitorAlert' because this table does not exist in database 'PolyMon'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.foreign_keys'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.MonitorAlert' because this table does not exist in database 'PolyMon'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.foreign_keys'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.MonitorAlert' because this table does not exist in database 'PolyMon'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.foreign_keys'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.MonitorOperator' because this table does not exist in database 'PolyMon'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.foreign_keys'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.foreign_keys'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.OperatorAlert' because this table does not exist in database 'PolyMon'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.foreign_keys'.


Coordinator
Jan 5, 2007 at 11:19 AM
Thanks for bringing this up.
I will fix this (and test under SQL 2000) for the upcoming RC 3 release.
Fred.
Coordinator
Jan 5, 2007 at 11:19 AM
This discussion has been copied to Work Item 7031. You may wish to continue further discussion there.
Coordinator
Jan 5, 2007 at 4:18 PM
Problem has been fixed.
Please see closed issue
SQL 2000 - Scripts - Syntax Error
in Issue Tracker.

thanks,
FB.