Type Property (Alert)

SQL-DMO

SQL-DMO

Type Property (Alert)

The Type property exposes configured attributes of the referenced Microsoft® SQL Server™ 2000 component.

Applies To
Alert Object
Syntax

object.Type

Parts

object

Expression that evaluates to an object in the Applies To list

Data Type

Long, enumerated

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetType(SQLDMO_ALERT_TYPE* pRetVal)

Returns

For the Alert object, interpret the Type property using these values.

Constant Value Description
SQLDMOAlert_NonSQLServerEvent 3 Alert will be raised by an event not defined for SQL Server.
SQLDMOAlert_SQLServerEvent 1 Alert will be raised when a specified SQL Server error condition, or any error condition of a specified severity, occurs.
SQLDMOAlert_SQLServerPerformanceCondition 2 Alert will be raised when a bound is reached or exceeded for a SQL Server counter evaluated by Windows Performance Monitor.

Remarks

The Type property is set by adjusting the event source for the alert. For more information, see MessageID Property, PerformanceCondition Property and Severity Property.