>>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.
No, it is not. Use varchar(max).
Cetin