vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| I am running a job from sql server agent that has a single step the looks like this exec q_spr_inlevextsystem this fails with the following message Job 'AutoInlev' : Step 1, 'Run the SP q_spr_inlevextsystem' : Began Executing 2004-04-05 09:00:00 output --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- (null) Starting copy... (null) 1 rows copied. Network packet size (bytes): 4096 Clock Time (ms.): total 1 (null) (0 rows(s) affected) Msg 8152, Sev 16: String or binary data would be truncated. [SQLSTATE 22001] Msg 3621, Sev 16: The statement has been terminated. [SQLSTATE 01000] but if I run the exact same command in query analyzer it works just fine. no error messages and the SP works as expected regards Matt |