title: Cannot find data type date in SQL Server 2005
body: <p>I am getting this error message while creating table with one of the column has data type as date</p>
  
  <blockquote>
    <p>Msg 2715, Level 16, State 7, Line 2<br>
    Column, parameter, or variable #11: Cannot find data type date.</p>
  </blockquote>
  
  <p>I have also tried to change the compatibility level </p>
  
  <pre><code>alter database test
  set compatibility_level = 90
  go
  </code></pre>
  
  <p>and received an error message </p>
  
  <pre><code>Msg 102, Level 15, State 1, Line 2  
  Incorrect syntax near '90'. 
  </code></pre>