Home Forums SQL Server 7,2000 SQL Server Agent Msg 8152, Sev 16: String or binary data would be truncated. [SQLSTATE 22001] RE: Msg 8152, Sev 16: String or binary data would be truncated. [SQLSTATE 22001]

  • 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!