Line 5: Incorrect Syntax near '1'

[Brian Donahue]

When comparing databases that are set to SQL Compatibility Level 65, SQL Compare will throw the error 'Line 5: Incorrect Syntax near '1''. This happens regardless if the actual database server is running the supported versions of SQL Server, which are 7, 2000, and 2005. The reason this happens is because the system table schema changes when a backwards-compatibility level is set on the database, and the system table schema of SQL Server 6.5 is not supported by SQL Compare.

In order to compare databases with SQL Compare, the compatibility level of the database must be '70' or higher.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521