SQL 2008 R2 SSMS Doesn’t Show Database Compatibility Levels on SQL 2012 Servers

I installed my first SQL 2012 server recently and came across an interesting issue I thought I’d share. When you connect to a SQL 2012 server using SSMS from SQL 2008 R2 and view the database options page, you do not see options for the database compatibility level.

Here is a look at the compatibility drop down for the model database on a SQL 2012 server using SQL 2008 R2 SSMS:

Click to enbiggen


And here is the same screen for the same database using SQL 2012 SSMS:

Click to enbiggen


Leave a Reply

Your email address will not be published. Required fields are marked *

I am a real person and can prove it by doing this math problem: (required) Time limit is exhausted. Please reload CAPTCHA.

This site uses Akismet to reduce spam. Learn how your comment data is processed.