SQL 2005 - Maximum number of characters displayed in each column - Raj Kaimal

SQL 2005 - Maximum number of characters displayed in each column

This setting in Microsoft SQL server management studio, which has a default setting of 256 characters, caused me to waste almost half an hour yesterday. I was looking in the wrong places trying to troubleshoot my stored procedure and wondering why my data was being truncated. There is no indication in management studio that the text was being truncated either.

To increase the maximum value, open SQL Server management studio and go to

 Tools » Options » Query Results » Results to Text » Maximum number of characters displayed in each column

Note also that there is a "Maximum Characters Retrieved" section under "Results to Grid" section too.

Published Thursday, September 27, 2007 12:52 PM by rajbk
Filed under: ,

Comments

# re: SQL 2005 - Maximum number of characters displayed in each column

I discovered this as you did in the SQL 2005 Studio. However, I have not discovered a similar solution to this same problem 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.

Any suggestions?

Thanks,

Pat G.

Tuesday, November 06, 2007 4:14 PM by Pat Grealy

Leave a Comment

(required) 
(required) 
(optional)
(required)