07-31-2023, 09:51 AM
In newer versions of SSMS it can be configured in the **(Query/Query Options/Results/Grid/Maximum Characters Retrieved)** menu:
[![enter image description here][1]][1]
---
## Old versions of SSMS
[Options (Query Results/SQL Server/Results to Grid Page)][2]
>>To change the options for the current queries, click Query Options on the Query menu, or right-click in the SQL Server Query window and select Query Options.
...
>> **Maximum Characters Retrieved**
>> Enter a number from 1 through 65535 to specify the maximum number of characters that will be displayed in each cell.
Maximum is, as you see, 64k. The default is much smaller.
BTW [Results to Text][3] has even more drastic limitation:
>> **Maximum number of characters displayed in each column**
>> This value defaults to 256. Increase this value to display larger result sets without truncation. The maximum value is 8,192.
[1]:
[2]:
[![enter image description here][1]][1]
---
## Old versions of SSMS
[Options (Query Results/SQL Server/Results to Grid Page)][2]
>>To change the options for the current queries, click Query Options on the Query menu, or right-click in the SQL Server Query window and select Query Options.
...
>> **Maximum Characters Retrieved**
>> Enter a number from 1 through 65535 to specify the maximum number of characters that will be displayed in each cell.
Maximum is, as you see, 64k. The default is much smaller.
BTW [Results to Text][3] has even more drastic limitation:
>> **Maximum number of characters displayed in each column**
>> This value defaults to 256. Increase this value to display larger result sets without truncation. The maximum value is 8,192.
[1]:
[2]:
[To see links please register here]
[3]:[To see links please register here]