Notification Alert System crash after any unrelated error of OLE DB initialization - by ellight1

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 775018 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 12/22/2012 7:32:38 AM
Access Restriction Public


We using log error notification service: SQL Server Agent -> Alerts
Correspondingly logging errors (RAISERROR WITH LOG;) sends message by e-mail to admins

If anywhere, any provider with external context run fails on initialization, then alert system will fall off. And only system/service restart restores it.

At the same time other mechanisms, such as providers, e-mail etc. continues normal function (though some of them doesn't immediately, it depends)

Links for settings instructions:

The use of an external context run is necessary due to problem providers with memory leaks and crashes (Oracle provider for example)
Sign in to post a comment.
Posted by Sethu Srinivasan on 2/3/2015 at 6:58 PM
Please install latest service pack and let us know if you still see this issue

Sethu Srinivasan [MSFT]
SQL Server