I wonder, Could you add a section to do something similar with an XML output? Standard in 2008 SSMS and 2012 SSMS is 2 MB of output text in XML.

So, for example use this:

DECLARE @LongString AS VARCHAR(MAX)

SET @LongString = STUFF((SELECT CASE WHEN t.Number % 16000 = 0 AND t.Number > 1 THEN Char(13) + Char(10) ELSE ',' END + CAST(t.Number AS VARCHAR(MAX))

FROM dbo.LargeTally t --Has 100,000 rows

FOR XML PATH(''), TYPE).value('.', 'VARCHAR(MAX)'), 1, 1, '')

SELECT [Value] = @LongString

FOR XML PATH('')