microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: Using Triggers as event provider and notification instance state

Subject: Re: Using Triggers as event provider and notification instance state
From: Joe Webb
Date: Tue, 05 Jul 2005 14:03:09 -0500
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Why not use the built in SQL Server Event Provider instead?  

-- 
Joe Webb
SQL Server MVP


~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811 

I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)


On Fri, 1 Jul 2005 09:46:05 -0700, "Hilda"
<[email protected]> wrote:

>Hi,
>
>I have my event provider based on triggers, but sometimes I need to disable 
>the notification isntance.
>The problem is that if the instance is disabled the firing trigger fails, 
>and all the transaction too.
>In the event log appers the error message "The notification instance is 
>disabled".
>
>Is there some way to make de firing of the tigger independent to the 
>notification instance state? I mean, some kind of queue, or mechanism to keep 
>the notification messages until the instance be enabled, but evoid the 
>trigger to fail.
>
>Thanks!


<Prev in Thread] Current Thread [Next in Thread>