Some of the data types are required conversion since they are deprecated in future versions of MSSQL Server

Microsoft SQL Server 2000:

[text]

Microsoft SQL Server 2008:

[varchar] (max)