varchar (max) not supported

I just started using VSTS for DP's and the first thing I noticed was after my import I have 97 errors, almost all of them due to varchar (max) not being supported. I found a bug listed for this on the connect site.

What are my options here? I don't want to go and change all my fields to text type, because my understanding is that text does not support the same type of queries as varchar(max). I suppose I could change them all to varchar(8000) but I'd prefer not to have to do that (and I have some varbinary fields where I don't think 8000 would be enough). Do I have any options here? What if I leave the errors present, will it prevent me from building and deploying?

[692 byte] By [Optikal] at [2008-2-18]
# 1

varchar(max, nvarchar(max) and varbinary(max) are SQL Server 2005 constructs, which are currently not supported in the CTP, CTP3 supports all SQL Server 2000 schema objects.

We are working on adding the parser support for understanding SQL Server 2005 objects in the coming CTP's.

-GertD

GertDrapers at 2007-9-10 > top of Msdn Tech,Visual Studio Team System,Visual Studio Team System - Database Professionals...
# 2
oh right, I should have known that. I remember having that drilled into my head at Tech-Ed. Thanks Gert.
Optikal at 2007-9-10 > top of Msdn Tech,Visual Studio Team System,Visual Studio Team System - Database Professionals...

Visual Studio Team System

Site Classified