>According to most of what I've read Max types are supposed to behave much better than TEXT etc
>But be aware that if you use the SQL Native Client with SPT you will have problems. Varchar(max) will return no data. ODBC driver ( 'SQL Server' ) works fine.
>
Can you please elaborate on that? I worked with SQL Native Client in .NET and varbinary(max) worked fine.
If it's not broken, fix it until it is.
My Blog