Line 5: Incorrect Syntax near '1'

Forum for users of SQL Compare schema synchronization utility

Moderators: JonathanWatts, Chris Auckland, David Atkinson

Line 5: Incorrect Syntax near '1'

Postby Brian Donahue » Mon Feb 20, 2006 6:26 pm

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
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests