A JOB error..SQL SERVER MANAGMENT STUDIO 2012

Oct 12 2018 9:24 AM

Hi Comunity,

I have a JOB with only one step scheduled to run each Saturday Monthly, but the JOB HISTORY show me the error listed below:

Executed as user: NT SERVICE\SQLSERVERAGENT. String or binary data would be truncated. [SQLSTATE 22001] (Error 8152) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.

Nevertheless the INSERT INTO in the Stored Procedure was execute successfully..

I guess it is a kind of Warning but not an error as such.

OOOHH PLEASE GOD HELP MEEE!!!

thanks a lots

Answers (3)

SQL connection problem with connection string

how do i return 0 from function when query return no record