在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
将截断字符串或二进制数据
