This question already has an answer here:

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?

marked as duplicate by Paul White, ypercubeᵀᴹ, Colin 't Hart, Michael Green, RolandoMySQLDBA Jul 20 '15 at 2:16

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.


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. – Aaron Bertrand 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.