title: How to determine if an instance of SQL Server is case sensitive or not
body: <p>How can I find out if an instance of SQL Server 2005 allows case sensitive databases or not?</p>
  
  <p>By case sensitive, I mean case sensitivity of the objects in the database, i.e. the following two statements are not equivalent:</p>
  
  <pre><code>SELECT * FROM TABLE
  SELECT * FROM table
  </code></pre>
  
  <p>I've looked in the property pages of the server (in Management Studio) but I couldn't see it.</p>