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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-06-12 : 01:24:09
|
| Dear All,what are the advantages of changing compatibility level from 80 to 90? are there any disadvantages doing this on production machine? will it take any downtime?i've searched the google but i didnt get the correct info.ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-12 : 01:34:17
|
| Changing compatability level to 90 will enable you to use many new features of SQL 2005 like PIVOT,APPLY,etc. The compatability level of 80 corresponds to SQL 2000.The disadvantages are any code which uses features that is not supported by SQL 2005 will break (like use of join syntax *=,=*,...) and also some of features of 2000 which is not supported by 2005.For detailed info on differences in behaviour refer thishttp://msdn.microsoft.com/en-us/library/ms178653.aspx |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-06-12 : 09:35:44
|
| http://sqlblogcasts.com/blogs/madhivanan/archive/2007/10/12/behaviour-changes-in-sql-server-2005.aspxMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
advantages of changing compatibility level