>Because at that time varchar did not have the MAX attribute and counted in recordsize which is 8060. Things have changed when SQL2005 came out.
So, is Text better to use? I also heard that the Text type will no longer be supported in the next version.