Export (0) Print
Expand All
Expand Minimize

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

SQL Server 2000

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

To create an alert using severity level

  1. Expand a server group, and then expand a server.

  2. Expand Management, right-click Alerts, and then click New Alerts.

  3. In the Name box, type a name for this alert.

  4. Select the Enabled check box to enable the alert to run.

  5. Click Severity, and then click a severity level.

    Severity levels from 19 through 25 send a Microsoft® SQL Server™ message to the Microsoft Windows® 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 application log.

  6. In the Database name list, click the database to restrict the alert to a specific database.

  7. In the Error message contains this text box, type a keyword or character string to restrict the alert to a particular character sequence.

    The maximum number of characters is 100.

See Also

How to define the response to an alert

Show:
© 2014 Microsoft