Alert Properties (General Tab)
Use this tab to view or specify the following options.
Options
Name
View or specify the name of the alert. The name is limited to 128 characters.
ID
View the ID generated for the alert by Microsoft® SQL Server™. New appears when you are creating a new alert.
Type
Specify the type of alert definition.
Enabled
Enable the alert. The alert is enabled by default.
Error number
Specify the error number that triggers the alert. Click the browse (...) button to display the Manage Server Messages dialog box, where you can view alerts according to error number. These options are only available when you select a SQL Server event alert.
Severity
Specify the severity level that triggers the alert. Available only when you select a SQL Server event alert.
Database name
Specify the database in which the error must occur to trigger the alert. Available only when you select a SQL Server event alert.
Error message contains this text
Restrict the alert to only those events containing the text specified in the error message. Available only when you select a SQL Server event alert.
Date last occurred
View the date and time the alert last occurred.
Date last responded to
View the date and time the alert last raised a response.
Occurrence count
View the number of times the alert has occurred since the count was last reset.
Reset Count
Reset the alert count.