In my project I was not using tables to hold the string...just variables. I tried building a variable with the very long string and then just doing a SELECT @VariableName but it only printed out 8,192 characters.

BTW, this is all on the 32-bit version of SQL Server.

SB