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 realize this is an old post - but perhaps others - like me find this entry due to a similar problem. In my case I had an insert statement with a select statement to load a reporting table. The solution turned out to be that I had a field name that had a space in it and I had used double quotes around the field (not smart) Once I changed it to [] around the field name the problem went away.