Hi,Please help me sort this error with my query using sqlserver 2005... which am getting when i run my application in vb.net ...Error is: 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. Query is:"SELECT CALLS.CALL_ID, REQUESTOR, USERS.USER_NAME REQUESTOR_NAME, DESCRIPTION, TYPE, SCOPE, SEVERITY, STATUS.STATUS_LABEL STATUS,FLAG MESSAGE_FLAG FROM CALLS,STATUS,USERS,MESSAGES WHERE REQUESTOR='" & Session("USER_ID") & "' AND CALLS.STATUS_ID <> 10 AND CALLS.STATUS_ID=STATUS.STATUS_ID AND CALLS.REQUESTOR=USERS.USER_ID AND CALLS.CALL_ID*=MESSAGES.CALL_ID ORDER BY CALLS.CALL_ID"Thanks a lot.
Please help me with this SQL SERVER error...in que
Posted - 2007-08-06 : 08:56:21
