Sorry for posting on such an old thread but I thought I would add to the thread for others to give another option...

You could also just add in a Maintenance...

hmmm...Haven't done any mirroring dealing with SSRS but my gut feeling is that it should be possible. Issues have to stem from the web access point to the reporting servers....

@echatzigeorgiou

OK, now first thing first, I would never condone doing any type of configuration changes without testing (and with this article using VM, it's a good idea to...

First thing, good article Brady.

With many topics, sometimes your going to get a lot of feedback (which is good) on little tidbits which may need "more" feeling out.

Hello All,

First, good job Tony for the article. If anything, always good to put ideas out there for a vibrant debate.

Now, I can unequivocally state that the performance aspect of...

None taken Gift,

Constructive criticism often leads to opened eyes...and always good for debate.

Makes me rethink options for my clients but for now, I've got SQL doing the job of about...

Point taken...

And hopefully that was a kind jab....

Never bothered to build with asp.net interface due to concerns for remote session timeouts...for mass mailing at least...

Dave

@Gift Peddie

I would tend to agree but would not suggest an asp.net app. .Net window application/console/service would probably be more intune with what your suggesting. asp.net apps. would not be...

Hey All,

I've been using the db_mail functionality for a while now and would just add in a couple of caveats:

1) You should add in some mechanism to track emails sent...

First, Great article...fairly objective (more neg than positive but realistic).

Just chiming in on my experiences dealing with XML in a DB aspect.

- MS has gone so far as to create...