What are the challenges you face when working across database platforms? Take the survey

Line 5: Incorrect Syntax near '1'

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited February 20, 2006 12:26PM in SQL Compare Previous Versions
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.
Sign In or Register to comment.