Good idea, I am already doing something similar.
I have a "test" mode that scans and creates all the messages, just skipping
over the "send".
This allows me to debug the code to the point where I handle most of the
potential data-exceptions gracefully.
The reason I want to hold the messages is that I can double-click the EML
files in Windows Mail or Outlook Express, and view them to check the HTML
formatting.
But in the long-run, your proposed intermediate result table makes a lot of
sense, thanks.
BTW, I notice your MCSD tag at the end. Mine worked out very well for me,
how about you?
"Mike" wrote:
> Why not use a Table to store all your emails and once successfully
> completed, send out all the emails or else you can trash the email or if it
> part of the transaction, you can rollback.
>
> Regards,
>
> Trevor Benedict
> MCSD
>
>
> "theartiststillknownasgarvin" <tommyg.DeleteThis@nospam.nospam> wrote in message
> news:D83D495E-13F6-4F22-BD0C-156C535DEC7F@microsoft.com...
> >I am in the final stages of testing an app that scans a SQL Server database
> > via SQL CLR (VB2008) and sends email notifications based on a variety of
> > data
> > conditions and deadlines.
> >
> > I need to have the equivalent of a "transaction", so that if the beta code
> > fails somewhere along the line, I am not stuck with sending out 500 of
> > 1000
> > potential messages, and then with the need to re-start in the middle so I
> > don't spam the first group again.
> >
> > In my development environment, I can set IIS 7.0 (Vista Business) to "...
> > store e-mail in a pickup directory..." and not worry about anything
> > leaking
> > out. I just delete all the outbound messages after spot-checking them
> > through
> > Outlook Express.
> >
> > I cannot find a similar option with IIS 6.0 (Win Server 2003).
> >
> > Is there on option like this?
> >
> > Or a way to have SMTP service accept messages, but pause the outbound
> > sending activity?
> >
> > Currently I set Outbound Security to Basic Authentication and enter a
> > bogus
> > user name, crude, but effective, but maybe also error-prone.
> >
> > Would prefer a legit solution.
> >
> > Extra bonus points for "elegant"
>
>
> >> Stay informed about: How to pause IIS SMTP outbound mail delivery for testing p..