Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
How to create an alert using an error number (Enterprise Manager)
Collapse the table of content
Expand the table of content

How to create an alert using an error number (Enterprise Manager)

SQL Server 2000

How to create an alert using an error number (Enterprise Manager)

To create an alert using an error number

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

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

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

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

  5. Click Error number, and then type a valid error number for the alert.

    When an error number is found in the sysmessages table, the error number message text is displayed. Otherwise, "Not a valid error number" is displayed.

    Note  To search for errors by message text, error number, or severity, click the browse (...) button to open the Manage SQL Server Messages dialog box.

  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, enter 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:
© 2015 Microsoft