Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question

1 Answer 1

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).

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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