Article ID: 966146 - View products that this article applies to.
Run-time error '-2147217900 (80040e14)':[Microsoft][ODBC SQL Server Driver][SQL Server]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 or lower, using stored procedure sp_dbcmptlevel. 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
This error occurs in any one of the following three instances:
This SMR has been fixed in R07670 Service Pack and subsequent Service Packs, please check or website () for availability of Service Packs for your General Ledger. You may also sign up for automatic notification of Services on our website .
To work around the issue, do the following to set the Compatibility Level of the Database to 80:
Contact us for more help
Connect with Answer Desk for expert help.