IncludeEventDescription Property

未來的 Microsoft SQL Server 發行版本將不再提供此功能。請避免在新的開發工作中使用此功能,並計劃修改目前使用此功能的應用程式。

The IncludeEventDescription property indicates response notifications that receive alert error text when a SQL Server Agent builds a notification message for an alert.

語法

object
.IncludeEventDescription [=value]

Parts

  • object
    An expression that evaluates to an object in the Applies To list.
  • value
    A long integer that specifies a response type as described in Settings.

Settings

Constant Value Description

SQLDMONotify_All

7

Notification is made by e-mail sent to the pager address and by a network pop-up message.

SQLDMONotify_Email

1

Notification is made by e-mail sent to the operator e-mail address.

SQLDMONotify_NetSend

4

Notification is made by net send message posted to the operator network address.

SQLDMONotify_None

0

No notification method is specified for the referenced operator.

SQLDMONotify_Pager

2

Notification is made by e-mail sent to the operator pager address.

Data Type

Long, enumerated

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetIncludeEventDescription(SQLDMO_NOTIFY_TYPE *pRetVal);
HRESULT SetIncludeEventDescription(SQLDMO_NOTIFY_TYPE NewValue);

備註

SQL Server Agent builds a notification message to send in response to a raised alert. For each notification method (e-mail, pager, or net send SQL Server Agent can build a different message. To include alert error text in a SQL Server Agent-built message, set the IncludeEventDescription property of the referring Alert object.

To specify that more than one notification method should include error text, combine values by using an OR logical operator.

Applies To:

Alert Object

請參閱

參考

Notification Method Constants (SQLDMO_NOTIFY_TYPE)
NotificationMessage Property

說明及資訊

取得 SQL Server 2005 協助