I've been looking into SQL Server alerts and it looks like I need to enable database mail on the server to be able to send e-mail alerts. The other solution appears to be to send those events to another server which already sends e-mail alerts (for log shipping), but in this case it appears that all alerts will be sent to the 'other' server.

Are there any reasons that I shouldn't enable database mail on the server generating alerts?

What might be the negative implications of sending all those alerts to another server to send e-mails?

In short, what do I need to look out for and which method is suggested?

link|improve this question

feedback

1 Answer

up vote 1 down vote accepted

Very happily, MS-SQL's mailer does support SMTP-Auth, so it is smart enough to actually log in to the SMTP server before sending mail. As a mail admin, this makes me happy.

The only downside is regular old email overload, or if the server generates so many alerts that it somehow overloads the mailer (unlikely).

link|improve this answer
No drawbacks? Excellent! Thank you! – pete the pagan-gerbil Sep 17 '10 at 15:15
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.