• You can use this procedure http://www.sqlservercentral.com/scripts/Print/63240/ to print out your data in chunks of 8000...I've used it in the past to debug dynamic SQL statements that way exceed 8000 characters and which fail at some obscure point(yep - that was fun)

    DECLARE @max-2 varchar(max);

    SET @max-2 = REPLICATE('X',8000);

    SET @max-2 = @max-2+'----This will not show up in PRINT';

    PRINT @max-2

    PRINT CHAR(13)+CHAR(13)

    PRINT REPLICATE('*',30)

    EXEC dbo.LongPrint @max-2