The Type property exposes configured attributes of the referenced Microsoft® SQL Server™ component.
object.Type
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
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 NT Performance Monitor. |
The Type property is set by adjusting the event source for the alert. For more information, see MessageID Property, PerformanceCondition Property and Severity Property.
Long, enumerated
Read-only
HRESULT GetType(SQLDMO_ALERT_TYPE* pRetVal)