title: Option to change database compatibility level disabled in SSMS2012
body: <p>I'm trying to use SQL Server Management Studio 2012 to alter the <strong>Compatibility level</strong> of a database, but the drop-down is disabled:</p>
  
  <p><a href="https://i.stack.imgur.com/LrrFH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LrrFH.png" alt="enter image description here"></a></p>
  
  <p>Why is the option disabled? How do i enable it?</p>
  
  <p>I try manually changing it using T-SQL:</p>
  
  <pre><code>ALTER DATABASE AsiQuanClient
  SET COMPATIBILITY_LEVEL =  110; --90 | 100 | 110 
  </code></pre>
  
  <p>and it is still disabled:</p>
  
  <p><a href="https://i.stack.imgur.com/czjle.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/czjle.png" alt="enter image description here"></a></p>
  
  <p>Why is it disabled, and how do i enabled it?</p>
  
  <h1>Bonus Chatter</h1>
  
  <blockquote>
    <p>Microsoft SQL Server Management Studio  11.0.3128.0</p>
  </blockquote>
  
  <pre><code>SELECT @@version
  
  Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64) 
      Dec 28 2012 20:23:12 
      Copyright (c) Microsoft Corporation
      Standard Edition (64-bit) on Windows NT 6.2 &lt;X64&gt; (Build 9200: ) (Hypervisor)
  </code></pre>