http://www.sqlservercentral.com/blogs/steve_jones/2009/09/21/built-in-alerts/

Printed 2014/10/24 09:56AM

Built In Alerts

By Steve Jones, 2009/09/21

The more I think about this, the more I think it should be built into SQL Server as a default. Why not ask for the information to create an operator and email at install and then create a few nice default alerts, like one for which log is full.

It's such a common problem, why not get people to enable DBMail and enter their email address during installation? For the people that really need to lock down their servers, they could skip it, but for the average person, it might save some headaches if they knew when their log was 80% full.

If you want the general steps for creating an alert, it's on MSDN.


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.