I've had Oracle (linked server) update problems before too. In that case it was because the MS driver for Oracle was great at getting data from Oracle, but wasn't...

Enterprise Manager's "Design Table" function has the ability to insert a column anywhere in the table rather than just at the end as an ALTER TABLE would do. BUT...

I agree you've probably been lucky until now. Any chance that your 3 variables have all contained the same date up until recently?

Fix list for SQL2000 SP3 has no...

The "count(*) - 1" bit is simply my interpretation of what is a "duplicate". If a line appears 4 times, then methinks we have 1 original plus 3 duplicates....

Try the following for a case-insensitive query against c:\temp\example.txt (assuming your SQL server is case-insensitive):

 

SELECT 

    COUNT(*)-1 AS Duplications,

   ...

Lixin,

Try the following script (blatantly hijacked from MS code). Schedule it to run maybe 10 mins before each scheduled time of your problem job.

...

You can try this. It doesn't do stuff like checking that you have enough overall capacity in your bins (you'll need another a separate error-checking query to do that)....

Lixin,

I've had a look at your previous post. Unfortunately I can't see exactly what the Vineftp SP does, but it may be prone to any number of ftp problems...

Narrie,

Try:

.

.

EXEC @hr = sp_OASetProperty @MailID, 'To', @To

-- Add the attachment file

EXEC @hr = sp_OAMethod @MailID, 'AddAttachment', NULL, 'InsertAttachmentPath&FileNameHere'

EXEC @hr = sp_OAMethod @MailID, 'Send', NULL

EXEC @hr = sp_OADestroy @MailID