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 |
|
raguyazhin
Posting Yak Master
105 Posts |
 Posted - 2011-01-10 : 01:35:33
|
| We use Sql server 2005 Enterprise with Sp3 platform.but our database compatibility level is Sql Server 2000(80)Now we plan to change Sql Server 2005(90).what are the Database changes we do ?--Ragu ThangavelJunior SQL Server DBA |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2011-01-12 : 08:54:37
|
| and you should run update stats with full scan or reindex all indexes after you change the compatibility level..Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-01-12 : 18:10:08
|
quote:
Originally posted by dinakar
and you should run update stats with full scan or reindex all indexes after you change the compatibility level..Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/
Not sure why this is needed - you have any documentation to support this?Changing compatibility level doesn't change the database structure, nor does it change the statistics or anything else. It just changes what functions/code are available.Jeff |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
compatibility level