Browsing Solutions For CBSFA

  • Clarify views that use non-ANSI join operators will fail in SQL Server 2008

    After upgrading to MS SQL Server 2008, querying specific views results in the following error: "The query uses non-ANSI outer join operators ("*=" or "=*"). To run this query without modification, please set the compatibility level for current database to 80, using the SET COMPATIBILITY_LEVEL option of ALTER DATABASE. It is strongly recommended to rewrite the query using ANSI outer join operators (LEFT OUTER JOIN, RIGHT OUTER JOIN). In the future versions of SQL Server, non-ANSI join operators will not be supported even in backward-compatibility modes."