Alert Properties (Alert Definition Tab)

Use this tab to view or specify the following options.

Type
Specify the type of alert definition.

Error number
Specify the error number that triggers the alert. Click the browse (...) button to display the 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
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.