在SQLAgent建立作业执行存储过程失败, 而在查询分析器执行则成功,求救!
利用作业执行存储过程:
    EXEC   SP1
调用作业报以下错误信息:
Executed   as   user:   sa.   String   or   binary   data   would   be   truncated.   [SQLSTATE   22001]   (Error   8152)     The   statement   has   been   terminated.   [SQLSTATE   01000]   (Error   3621)     Associated   statement   is   not   prepared   [SQLSTATE   HY007]   (Error   0)     String   or   binary   data   would   be   truncated.   [SQLSTATE   22001]   (Error   8152)     The   statement   has   been   terminated.   [SQLSTATE   01000]   (Error   3621).     The   step   failed.

而当我在查询分析器输入同样的语句(EXEC   SP1)执行,却没有报错.请各位高手指教.


------解决方案--------------------
有数据超出范围了？字符串过长？
------解决方案--------------------
String or binary data would be truncated

将截断字符串或二进制数据