title: How to remove Case Sensitive check in SQL Server 2008?
body: <p>I just installed SQL Server 2008 and imported AdventureWorksDatabase (for SQL 2005, as for 2008 that didn't worked). </p>
  
  <p>It is now enforcing case sensitivity when I searched for any tables, views etc
  Hence Person.contact table when written throws an error of Invalid column name, but when Person.Contact is written it shows all rows.</p>
  
  <p>Plus the intellisense too doesn't work great.</p>