Converting Database Compatability...

3 May 2006 4:56 PM

Ademar

From 70 to 80 or 90. Any right-ups on this? A single document perhaps?
I'm wondering what would be any possible implications in converting my
database to 80 or 90.

Thanks,
Ademar.

3 May 2006 9:18 PM

Sue Hoegemeier

You use a lower compatibility level to address unforeseen
issues when you upgrade. It provides a window of time to fix
the issue and then you put it back to the appropriate level
for the version you are running.
You can find the documentation on this in books online under
sp_dbcmptlevel

-Sue

On Wed, 3 May 2006 09:56:38 -0700, "Ademar"
<ademar@nospam.com> wrote:

Show quote

>From 70 to 80 or 90. Any right-ups on this? A single document perhaps?
>I'm wondering what would be any possible implications in converting my
>database to 80 or 90.
>
>Thanks,
>Ademar.
>

3 May 2006 9:54 PM

Ademar

Thank you very much.

Ademar.

Show quote

"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:fb7i52tumnle071js773dmafstc9lgidgj@4ax.com...
> You use a lower compatibility level to address unforeseen
> issues when you upgrade. It provides a window of time to fix
> the issue and then you put it back to the appropriate level
> for the version you are running.
> You can find the documentation on this in books online under
> sp_dbcmptlevel
>
> -Sue
>
> On Wed, 3 May 2006 09:56:38 -0700, "Ademar"
> <ademar@nospam.com> wrote:
>
>>From 70 to 80 or 90. Any right-ups on this? A single document perhaps?
>>I'm wondering what would be any possible implications in converting my
>>database to 80 or 90.
>>
>>Thanks,
>>Ademar.
>>
>

3 May 2006 9:46 PM

Erland Sommarskog

Ademar (ademar@nospam.com) writes:

> From 70 to 80 or 90. Any right-ups on this? A single document perhaps?
> I'm wondering what would be any possible implications in converting my
> database to 80 or 90.

While sp_dbcmptlevel is a database setting, there is no conversion going
on. It's just a switch that you can flip forth and back. Depending your
code, some code can stop/start working when you flip the switch.

--
Erland Sommarskog, SQL Server MVP, esq***@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