gbaytler (10/7/2010)
Column in the application is defined as 'DATE', which is not available as a datatype in SQL Server 2005. It is introduced in SQL Server 2008.The article text should be changed to indicate that SQL Server 2008 is required.
Here is a specific fix for SQL Server 2005, which is not really supported any more:
First of all start the whole procedure over with a blank database. But before you start populating the database, edit the file “DataTypes.sql”. In there you will find these two lines:
exec sp_addtype 'DTDate', 'date', 'null'
exec sp_addtype 'DRDate', 'date', 'not null'
Change the ‘date’ types to ‘datetime’. Then start populating the database from scratch according to the instructions. This should then work with SQL Server 2005.