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)

  • use sp_help TABLENAME from production and archive, and checked if data type are same in both table.

    in this case our interest is PK column