Posted by Neil on 10/01/59 11:38

Thanks, and thanks for the note about Access 2003 and SQL 2005.

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns9758F0BBCCE23Yazorman@127.0.0.1...
> Neil (nospam@nospam.net) writes:
>> Erland mentioned "compatibility level 90" as possibly entailing some
>> incompatibilities. Would you concur?
>
> You can choose compatibiliy level 70. There still are cases of what
> is is illegal syntax bot not caught by SQL 2000. (Don't know if SQL 7
> has the same issues.) But with compatibility level 70, some functionalit
> will not be available to you.
>
> Beside mew reserved keywords, the main issue is the old-style outer
> join (*= and =*) that are not permitted in level 90. If you have this,
> rewrite it, because this is crap.
>
> Note that you could run into issues if you upgrade to SQL 2000 as
> well, althogh I think difference between level 70 and 80 is just
> three keywords.
>
>
> I've seen some mentions that Access 2003 is not co-operative with SQL2005,
> but you probably get better answer on that in an Access newsgroup.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]