title: H2DB - MS SQL Server Compatibility mode not working
body: <p>I am trying to write unit/integration test cases for a Java codebase connecting to MS SQL Server. In this effort, am able to successfully copy all my SQL Server tables over to a H2 Database file and run my unit tests on the H2 DB.</p>
  
  <p>I have thoroughly reviewed the H2 DB <a href="http://www.h2database.com/html/features.html#compatibility" rel="nofollow noreferrer">Compatibility</a> features. </p>
  
  <ol>
  <li>On my JDBC URL, I have the mode set -
  jdbc:h2:~/test;MODE=MSSQLServer </li>
  <li><p>Attempted connecting to the H2DB file and executed</p>
  
  <p>SET MODE MSSQLServer</p></li>
  <li><p>I attempted this on both in-memory and file mode and both are not working in compatibility mode.</p></li>
  </ol>
  
  <p>Both these do not seem to work. My application SQLs contain NOLOCK hints and identifiers with square brackets. Both these are quoted to be supported in the compatibility documentation. I even reviewed the H2DB's github for their MS SQL Server <a href="https://github.com/h2database/h2database/blob/master/h2/src/test/org/h2/test/db/TestCompatibilitySQLServer.java" rel="nofollow noreferrer">unit test</a> and found these to be supported.</p>
  
  <p>Still wondering anything that I may be missing.</p>