Management Studio Truncates Coloumns That Are Larger Then 8192 Bytes

This is a problem which has no solution with SSMS. You can run your script with sqlcmd, it does not truncate result set columns when set correct parameter.