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?

