Microsoft KB Archive/275025

= BUG: Cannot Design Table in SQL Server Enterprise Manager if Database Compatibility is Set to 60 =

Article ID: 275025

Article Last Modified on 10/17/2003

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q275025



BUG #: 58442 (SQLBUG_70)

BUG #: 236419 (SHILOH)



SYMPTOMS
Designing an existing table in SQL Server Enterprise Manager (SEM) results in a blank window if the database is set to 6.0 compatibility mode. When you try to save a new table that was created in the Table Designer the following error message occurs:

ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1:

Incorrect syntax near 'full'.

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax

near 'full'.

The SQL Server 2000 Enterprise Manager displays this error message when designing an existing table or when saving a new table.



CAUSE
In the 6.0 compatibility mode a FULL OUTER JOIN is not a recognized join type.



WORKAROUND
To work around this behavior set the compatibility mode of the database to 65 or higher. For example: sp_dbcmptlevel 'database', 70 where database is the name of the database that is experiencing the problem.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Keywords: kbbug kbcodesnippet kbpending KB275025

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.