Home Forums SQL Server 2008 T-SQL (SS2K8) SQL Agent Job Error - String or binary data would be truncated. [SQLSTATE 22001] (Error 8152) RE: SQL Agent Job Error - String or binary data would be truncated. [SQLSTATE 22001] (Error 8152)

  • I'm having trouble with what seems to be this exact issue. I have a stored procedure that has been working for years, and suddenly I get this error about string or binary data being truncated. I inferred the stored procedure in which the error occured, ran it manually to identify the errant statement, but no dice, it ran just fine. Numerous iterations of speculative fixings produced nothing, until I tried SET ANSI_WARNING OFF. SQL Job Monitor reported the same error as before, but my custom log table shows that the process actually made it a little farther than before. 

    If ANYONE has a clue why this is happening, please reply! I suspect that this error is internal to the SQL Job processor, and not related to the code. Thanks!