title: SQL Server compatibility mode
body: <p>We're currently running a server on Compatibility mode 8 and I want to update it. </p>
  
  <ul>
  <li>What are the implications of just going in and changing it? </li>
  <li>What is likely to break? </li>
  <li>Is there anything that checks the data will survive before I perform it? </li>
  <li>Can I rollback to mode 8 without performing a restore and without loss of data?</li>
  </ul>