Just found that in SQL Server 2005, we can use  varchar(max) to make varchar column to be able to store up to 2G data just like “text”.  Before that it’s only 8K.

Reference:  http://msdn2.microsoft.com/en-us/library/ms176089.aspx