Severity Property (SQL-DMO)

The Severity property identifies a Microsoft® SQL Server™ error message severity level to a SQL Server Agent alert.

Applies To

Syntax

object.Severity [= value]

Part	Description
object	Expression that evaluates to an object in the Applies To list.
value	Long integer specifying a SQL Server error message severity level. A number from 1 through 25 is a valid severity level.

Remarks

A SQL Server Agent alert is raised when a SQL Server process raises a specific error or an error of a specific severity level. Setting the Severity property of an Alert object associates an alert with a specific SQL Server error message severity level.

Setting both the Severity and MessageID properties of an Alert object attempts to associate an alert with both an error message severity level and an error message, which results in an error.

Data Type

Long

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetSeverity(LPLONG pRetVal)

HRESULT SetSeverity(long NewValue)