We are on SQL Server 2008 R2 and have DBs compatibility level set to SQL 2000 or 2005.

What are differences in compatibility level across the versions ?

Are there any advantages changing it to 2008 or higher?


There are plenty of differences. One that comes to mind right away is the MERGE statement, which first became available in 2008.

  • MERGE works fine regardless of compatibility level, though. Jul 19 '15 at 20:22
  • Good point. I was thinking of version rather than compatibility level.
    – TLaV
    Jul 19 '15 at 20:33

Not the answer you're looking for? Browse other questions tagged or ask your own question.