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 |
|
Sarakumar
Posting Yak Master
108 Posts |
 Posted - 2009-11-04 : 01:08:33
|
| Hai, what do u mean by database compatibility. i tried changeing the database compatibility with the following command EXEC sp_dbcmptlevel 'myDB', 80after that i check the version and gives the following Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1) Why do we need to use that...if i set the compatibility level, still can i utilize the full futures of SQL server 2000 db..Pls advise.Sara |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-11-04 : 03:11:23
|
| Compatibility 80 is for SQL Server 2000. You can use full features of itMadhivananFailing to plan is Planning to fail |
 |
|
|
Sarakumar
Posting Yak Master
108 Posts |
Posted - 2009-11-04 : 04:09:34
|
| i understand that..but why do we use compatibility..what is the difference between version and compatiblity?Cannot get it clearly???pls help |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
|
|
Database Compatibility