Hi,

After running the sql server 2005 upgrade advisor, one of the items says "When a databse is upgraded to sql server 2005 from any earlier version of sql server, the database retains its existing compatibility level. The following compatibility-mode differences may afftect your applications if you change the compatibility mode to 90 after upgrading" and it gives a long list of things that could break.

The default mode for sql 2000 = 80 and the default mode for sql 2005 = 90.

Is there any reason to actually change the compatibility level to 90 after you perform an upgrade since it sounds like the databases will retain their old compatibility level and the applications would still work under that old level?

Thanks.

Luanne

MS Sql Server LazyDBA home page