Cannot find data type date in SQL Server 2005

Question

I am getting this error message while creating table with one of the column has data type as date

Msg 2715, Level 16, State 7, Line 2
Column, parameter, or variable #11: Cannot find data type date.

I have also tried to change the compatibility level

alter database test
set compatibility_level = 90
go

and received an error message

Msg 102, Level 15, State 1, Line 2  
Incorrect syntax near '90'. 

Answer 1

SQL Server 2005 only supports the datetime (and smalldatetime) data type.

See http://msdn.microsoft.com/en-us/library/ms187752%28v=sql.90%29.aspx