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


The information in this article applies to:

  • Microsoft SQL Server 7.0
  • Microsoft SQL Server 2000 (all editions)
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.
Modification Type:MajorLast Reviewed:10/17/2003
Keywords:kbBug kbCodeSnippet kbpending KB275025
©2003 Microsoft Corporation. All rights reserved.