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.