How to create an alert using severity level (Enterprise Manager)

To create an alert using severity level

1. Right-click Alerts; then click New Alerts.
2. In the New Alert Properties dialog box, in the Name box, enter a name for this alert.
3. Select Enabled to enable the alert to run.
4. Click Severity, then click a severity level.

   Severity levels from 19 through 25 send a Microsoft® SQL Server™ message to the Microsoft Windows NT® application log and trigger an alert. Events with severity levels less than 19 will trigger alerts only if you have used sp_altermessage, RAISERROR WITH LOG, or xp_logevent to force them to be written to the Windows NT application log.

5. In the Database name list, click the database to restrict the alert to a specific database.
6. In the Error message contains this text box, enter a keyword or character string to restrict the alert to a particular character sequence. The maximum number of characters is 100.
7. Click the Response tab to define the response for the alert.

See Also

How to define the response to an alert