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

To create an alert using an error number

1. Right-click Alerts; then click New Alert.
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. Select Error number, then enter 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 browse (...) to open the Manage SQL Server Messages dialog box.

   ---

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