• 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 varchar(max);

    SET @Max = REPLICATE('X',8000);

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

    PRINT @Max

    PRINT CHAR(13)+CHAR(13)

    PRINT REPLICATE('*',30)

    EXEC dbo.LongPrint @Max