Transact-SQL Reference
@@TEXTSIZE
Returns the current value of the TEXTSIZE option of the SET statement, which specifies the maximum length, in bytes, of text or image data that a SELECT statement returns.
Syntax
@@TEXTSIZE
Return Types
integer
Remarks
The default size is 4096 bytes.
Examples
This example uses SELECT to display the @@TEXTSIZE value before and after it is changed with the SET TEXTSIZE statement.
SELECT @@TEXTSIZE
SET TEXTSIZE 2048
SELECT @@TEXTSIZE
Here is the result set:
------------------------
64512
------------------------
2048