Hi

when I put this update statement
    UPDATE    PContracts
    SET      Status = 'Expire'
    WHERE    DATEDIFF(day, EndDate, GETDATE()) >= 0
in job sql server 2000 and schedules it everyday, it didn't run and produce
a error messege.
Executed as user: GMS_DOM\Administrator. String or binary data would be
truncated. [SQLSTATE 22001] (Error 8152)  The statement has been terminated.
[SQLSTATE 01000] (Error 3621).  The step failed.

but it run well if i used sql quesy analyer

please tell me the reason

thank you in adv

wen ou

Are you working with the same database and table in Query Analyzer and the
job?

I suggest you look at the length of the Status column and make sure it can
accommodate the word 'Expire'.

More info on this issue at: http://vyaskn.tripod.com/programming_faq.htm#q1
when I put this update statement
UPDATE PContracts
SET  Status = 'Expire'
WHERE DATEDIFF(day, EndDate, GETDATE()) >= 0
in job sql server 2000 and schedules it everyday, it didn't run and produce
a error messege.
Executed as user: GMS_DOM\Administrator. String or binary data would be
truncated. [SQLSTATE 22001] (Error 8152)  The statement has been terminated.
[SQLSTATE 01000] (Error 3621).  The step failed.

but it run well if i used sql quesy analyer

please tell me the reason

thank you in adv

wen ou

Transaction Log is full
How get column headers in QA CSV export
if elseif .. in Store procedure:
DTS Programming Question -- how to remove custom transformations
Errors in the trace from Enterprise manager
windows 2003 and Sqlserver2000
SQL Mail and Replication Alerts
Located databases no longer used.
Disk fragmenation for sql server
Performance Monitor locking counter