Stuart Mark Housden (9/8/2008)
I had this same problem where I always get the "truncation" message when executing stored procedures in SQL Server Agent jobs but never getting the message when I run it in Management Studio.After trying a number of desperate measures I commented out some "Print" statements I had and the error messages went away.
This was my problem. Thanks!