Limits of @@textsize

select statements return text and image data up to the limit specified in the global variable @@textsize. The set textsize command is used to change this limit. The initial value of @@textsize is 32K; the maximum value for @@textsize is 2147MB.