Why not use the built in SQL Server Event Provider instead?
SQL Server MVP
Get up to speed quickly with SQLNS
I support PASS, the Professional Association for SQL Server.
On Fri, 1 Jul 2005 09:46:05 -0700, "Hilda"
<[email protected]> wrote:
>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
>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.