sql server notification services: I would like to know how any of you are handling the returned email from a
message sent via CDOSYS on SQL server.
We are using it to send out subscription renewals nightly in mass and if the
email account we are sending it to is no longer valid, we want to be
notified. We would like to be notififed even if it does get sent perhaps.

Hello,
I'm assuming your question pertains to sending of email notifications with
SQL Notification Services...

There is no explicit support in SQL-NS for handling mail that isn't
delivered after it gets to the mail server. SQL-NS only deals with delivery
failures between the distributor and the configured SMTP server. If you do
want your application to react to mail delivery failures that occur after
the SMTP server takes possession of the message, you need to build a custom
event provider that detects the NDR messages returned from the mail server
and then submits "Email Delivery Failure" events into your SQL-NS
application. From there, you can build a match rule that takes the
appropriate action (regenerate the notification, generate a different
notification etc).

Hope this helps.
-shyam

--
Learn more about SQL-NS:
http://www.amazon.com/exec/obidos/tg/detail/-/0672326647/
---------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
---------------------------------------------
[quoted text, click to view]