You are here: Re: Migrating to SQL 2003 « MsSQL Server « IT news, forums, messages
Re: Migrating to SQL 2003

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

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация