How to set up a SQL Server database alert (Windows NT)

How to set up a SQL Server database alert (Windows NT)

To set up a SQL Server database alert

1. On the View menu, click Alert.
   
   
2. On the Edit menu, click Add to Alert.
   
   
3. In the Object list, click a SQL Server object, and then in the Counter box, click a counter on which the alert will be based.
   
   
4. Under Alert If, click either Over or Under, and then enter a threshold value.

   The alert will be generated when the value for the counter is more than or less than the threshold value (depending on whether you click Over or Under).

5. Click First Time or Every Time to determine how often the alert is generated.

   The default is Every Time.

See Also

Creating a SQL Server Database Alert