SQL Server error code
SQL Server error 4147
SQL Server raises error 4147 at severity 15, which marks a problem with the query or data that you can correct.
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. | Msg | 4147 |
|---|---|
| Severity | 15 |
| Group | 4000–4999 |