Type Property (Alert)
Esse recurso será removido em uma versão futura do Microsoft SQL Server. Evite usar esse recurso em desenvolvimentos novos e planeje modificar os aplicativos que atualmente o utilizam.
The Type property exposes configured attributes of the referenced Microsoft SQL Server component.
Sintaxe
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. |
Comentários
The Type property is set by adjusting the event source for the alert. For more information, see MessageID Property, PerformanceCondition Property, and Severity Property.