Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-06-02 : 08:08:45
|
| Jim writes "First question had incorrect email address.We have a vendor who wants to upgrade our sql server to sql 2000. We are currently at sql 7.0. What I have found out is that the db version is really at 6.5. I have done a little research but don't understand the relationship of the server version to the db version, other than some values become reserved words in later versions? I asked the vendor if the db version will be upgraded with the new sql server version and they said no. If the db version stays at 6.5 what does sql server 2000 buy me?" |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2003-06-02 : 11:03:55
|
quote:
Even when the database compatibility level is set to 60 or 65, applications gain almost all of the benefits of the new performance enhancements of SQL Server 2000. Applications still benefit from features such as the improved query processor.
Lookup sp_dbcmptlevel in BOL.Jeff Banschbach, MCDBA |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-06-02 : 13:23:44
|
| Why does the DB version need to stay at 6.5? Does the application use deprecated reserved words?It seems kinda silly to still have a SQL 2000 server in 6.5 compatability mode.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-06-02 : 13:30:55
|
I've got an idea...Buy a Porsche, rip the motor out, and replace it with a 5 hp lawn mower engine...great gas mileage... Brett8-) |
|
|
|
|
|
|
Upgrading to sql 2000