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 |
|
itsonlyme4
Posting Yak Master
109 Posts |
 Posted - 2015-01-28 : 10:58:34
|
| Is there any harm in swapping between 80 and 100 compatibility mode for user databases? We installed SQL Server 2008 R2 and then restored Databases from a SQL Server 2005 instance. I set the compatibility level on all of the users database to '100'ALTER DATABASE [Admin] SET COMPATIBILITY_LEVEL = 100and now I would like to set several of them back to '80'Is there are harm in jumping back and forth like this between compatibility levels? I'm assuming I can go from '80' to '100' and back again with not problems..... |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2015-01-28 : 11:55:20
|
You can go back and forth but why would you want to keep changing? The issue with setting compatibility level is that there are some differences in the capabilities of each version. Most of the time, these are not a problem but in the worst cases can cause a system to not operate as expected. If you need SQL 2000 compatibility, set it and forget it. If you don't need a specific version, let it float to the highest level.
Those who will not reason, are bigots, those who cannot, are fools, and those who dare not, are slaves. -Lord Byron, poet (1788-1824) |
 |
|
|
|
|
|
Setting Compatiblity Mode