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

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