Top n and Compatability Level

[Udle]

How do I check the compatability level of a database?
The db in question was originally created in SQL 6.5 and converted to 7.0. Would this have reset the compatability level to 7 or left it at 6.5?
If it is at 6.5 what are the implications of changing it to 7?

Ray, if you answer this can you please forward me your email address. Thanks.

[Ray Miao]

sp_dbcmptlevel.


------------
Udle at 8/16/00 3:58:57 PM

How do I check the compatability level of a database?
The db in question was originally created in SQL 6.5 and converted to 7.0. Would this have reset the compatability level to 7 or left it at 6.5?
If it is at 6.5 what are the implications of changing it to 7?

Ray, if you answer this can you please forward me your email address. Thanks.

[Craig]

When upgrade wizard upgrades, it leaves the database in 6.5 comp. mode.


------------
Ray Miao at 8/16/00 4:31:43 PM

sp_dbcmptlevel.


------------
Udle at 8/16/00 3:58:57 PM

How do I check the compatability level of a database?
The db in question was originally created in SQL 6.5 and converted to 7.0. Would this have reset the compatability level to 7 or left it at 6.5?
If it is at 6.5 what are the implications of changing it to 7?

Ray, if you answer this can you please forward me your email address. Thanks.

[Jack Cole]

I was searching for this topic, and ran a compatibility check on my databases in a similar situation - problem is that they are all 6.0, 6.5 and 7.0 compatible, both those that run TOP N and those that don't. Are there any other reasons why this won't work?

With thanks,
Jack Cole
JKCole@magellanhealth.com


------------
Udle at 8/16/00 3:58:57 PM

How do I check the compatability level of a database?
The db in question was originally created in SQL 6.5 and converted to 7.0. Would this have reset the compatability level to 7 or left it at 6.5?
If it is at 6.5 what are the implications of changing it to 7?

Ray, if you answer this can you please forward me your email address. Thanks.