Last year I hosted LimeSurvey on my web site and it worked a treat. It used the same SQL Server 2005 as is installed now. I have recently upgraded to v. 1.92 (120501).
Unfortunately if I use DATE fields in any of my surveys, whether new or imported, then I get the following error when trying to activate any of them: "Cannot find data type DATE" (see error attached). The SQL Server 2005 backend database has a database COMPATIBILITY_LEVEL = 90.