Type Property (Alert)
В будущей версии Microsoft SQL Server эта возможность будет удалена. Избегайте использования этой возможности в новых разработках и запланируйте изменение существующих приложений, в которых она применяется.
The Type property exposes configured attributes of the referenced Microsoft SQL Server component.
Синтаксис
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. |
Замечания
The Type property is set by adjusting the event source for the alert. For more information, see MessageID Property, PerformanceCondition Property, and Severity Property.