BUG: Alert May Fail to Send E-mail Notification with xp_logevent or RAISERROR (262258)


The information in this article applies to:

  • Microsoft SQL Server 7.0
  • Microsoft SQL Server 2000 (all editions)
This article was previously published under Q262258
BUG #: 57890 (SQLBUG_70)

SYMPTOMS

An alert may not send e-mail notification when an xp_logevent or RAISERROR statement is run in conjunction with a logged server message.

CAUSE

This failure occurs if the alert is defined to be restricted to a specific database other than the master database.

WORKAROUND

If the alert is defined on the master database, or all databases, the e-mail notification runs successfully.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Modification Type:MajorLast Reviewed:10/17/2003
Keywords:kbBug kbpending KB262258
©2003 Microsoft Corporation. All rights reserved.