SQL Server 2000 and 2005 Compatibility
Posted on 2009-05-04
I have a SQL server 2000 database running on SQL 2005 engine with compatibility mode set to 2000.Now when i generate my database script and run it on the 2005 database i get 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 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.
I tried to check on the issue and one of the Store proc had following
select @OverRiddenValue = OverriddenAmount from
TaxPosition tp, PreAdoptionData Pd
where tp.id *= pd.PositionId
and pd.PeriodYear = @PreAdoptionYear
and pd.PeriodQtr = @PreAdoptionQtr
and tp.id = @PositionId
Can any one tell me how to fix this.