Apr 192007

After responding to a post from a mailing list regarding strange truncation of varchar(8000) fields when added together as a varchar(max), I noticed that I could only get 64K of text out of SSMS to the clipboard, although the length of the field was reporting the correct length.

It turns out that there is an option in SSMS to control the size of the result set, with defaults of 64K for a non-XML grid, 2MB for XML in a grid, and 256 characters in Text/Save to File. These options are available under the Tools | Options | Query Results | SQL Server section.

 Leave a Reply



You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>