At each month-end, we have several SQL 2000 jobs that mail that send out attached spreadsheets (local volume on the SQL server) to various recipients. Recently, some of them started showing up unable to be opened. The error messages usually
allow you to click through, but the data is spread across a couple of worksheets and is not formatted properly.
If the job is re-run, the attachment is sometimes delivered in a readable fashion, other times it is not.
A separate test script that performs the same function seems to always deliver a usable spreadsheet attachment.
We have no reason to believe it is the email or local virusscan (TrendMicro OfficeScan, TrendMicro ScanMail for Exchange), since we have appropriate exceptions in place.
A search for relavent articles on "SMTP SENDMAIL CORRUPTION" doesn't turn up any obvious hits, so I don't think this is widespread or common.
Anybody with some input?
View Complete Post