Prev: SQL Azure Forum on MSDN
Next: What is File = 1
From: tshad on 5 Apr 2010 20:23
When you change the compatibility level of a database, does it check to see
if all the objects are compatible at that point or only when you start using
it.

For example, if you have a non-ansi join, which is not compatible in 2008,
will it tell you automatically that you have a problem or will it wait until
you run the procedure before it tells you?

Also, if you take a backup of a 2000 or 2005 database and restore it on a
2008 Server, will it automatically try to convert it?

Thanks,

Tom


From: Tibor Karaszi on 6 Apr 2010 01:17
It doesn't check anything existing when you change compat level. Use the
upgrade advisor tool for those things.


> Also, if you take a backup of a 2000 or 2005 database and restore it on a
> 2008 Server, will it automatically try to convert it?

It is physically upgraded to 2008 format, but compatibility level stays.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi



"tshad" <tfs(a)dslextreme.com> wrote in message
news:eVzbU9R1KHA.5212(a)TK2MSFTNGP05.phx.gbl...
> When you change the compatibility level of a database, does it check to
> see if all the objects are compatible at that point or only when you start
> using it.
>
> For example, if you have a non-ansi join, which is not compatible in 2008,
> will it tell you automatically that you have a problem or will it wait
> until you run the procedure before it tells you?
>
> Also, if you take a backup of a 2000 or 2005 database and restore it on a
> 2008 Server, will it automatically try to convert it?
>
> Thanks,
>
> Tom
>
 | 
Pages: 1
Prev: SQL Azure Forum on MSDN
Next: What is File = 1