How to change the maximum number of character displayed in SQL server Query analyzer and Management studio
Posted on 1/24/2008 5:57:16
in #SQL SERVER
Hi,
One of the very simple and common that one of the commenter asked me a few days ago was why does the SQL query analyzer show only results unto 255 character only and not full column text. This is common to any data type in SQL server Query Analyzer.
The maximum number of character displayed using the tools->Option menu. Go to the result Tab and change the 'Maximum characters per column'. BY default the value is set to 255. The maximum value allowed here is 8192 character.
In SQL Management studio (for SQL server 2005) go to Tools->Options, expand Query Results / SQL Server / Results to Text, and change the setting for "Maximum number of characters displayed in each column.. Note that in Results to Grid, you can send 65,535characters; however, results to text is still limited to 8,192 character only
Vikram
|
Posted on 4/2/2008 7:02:11 AM
How can i select characters greater than 8192. because my requirement is to select xml file from field that xml file can be greater than 10,000 characters
thanks in advance
|
Posted on 4/2/2008 11:17:19 AM
Hi,
Do you have a similar solution to this problem for Visual Studio? If I execute SQL code in the Visual Studio 2005 IDE. The results go to the Output Window and truncate at 256 characters, whether line-wrap is on or off.
|