I understand that SQL MAIL is a deprecated feature of SQL, thru SQL 2008r2. However, I am despirate to continue using the READ and DELETE funcationality as long as I can. Anyway...
I am running SQL 2005 (build # 9.0.4262). I am connecting to a company Exchange account via the SQL MAIL / MAPI system procedures.
I am very sure my code is good, as it runs on three different SQL installations, every 10 minutes. I eliminate 'auto reply', 'user replies', etc. from my three different account inboxes, and therefore keep those inboxes very clean.
I am unable to get the process "xp_findnextmsg" to return a message-ID for any messages with "Undeliverable:" in the subject line. I did send one 'TEST' email (from my account) into the account inbox and "xp_findnextmsg" does return a message-ID
for that one. My research indicates that the "Undeliverable:" replies from Exchange servers may have special headers.
Has anyone else encountered this issue, and/or a solution?
I have accumulated over 600 "Undeliverable" messages in my inbox, as my MS Report Server 2005 uses this account for Subscriptions. I would love to read the Subject and first 'x' characters of Body into a SQL table, so I can build SSRS reports back
out to report/subscription owners.
View Complete Post