While developing one store proc i face problem of varchar(max)
my string was genreated more than 100000 charactes and by default varchar(max) size is 65,536
actual size of any max type is 2^30-1
if you place max text size is 1 then it set to max available size