Type Property (Alert)
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The Type property exposes configured attributes of the referenced Microsoft SQL Server component.
Syntax
object.Type
Parts
- object
An 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 |
An alert is raised by an event not defined for SQL Server. |
SQLDMOAlert_SQLServerEvent |
1 |
An alert is raised when a specified SQL Server error condition, or any error condition of a specified severity, occurs. |
SQLDMOAlert_/SQLServerPerformanceCondition |
2 |
An alert is raised when a bound is reached or exceeded for a SQL Server counter evaluated by System Monitor in Microsoft Windows. |
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.