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

Re: Inconsistent Double Notifications

Subject: Re: Inconsistent Double Notifications
From: Joe Webb
Date: Thu, 20 Oct 2005 15:06:17 -0500
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Just catching up on posts. Good advice, Kate! Thanks for sharing!

Joe



-- 
Joe Webb
SQL Server MVP
http://www.sqlns.com


~~~
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 18 Oct 2005 12:20:58 -0700, "kate" <[email protected]> wrote:

>by stamping the incoming event and carrying this across to the
>notification we can tell at a glance if our problem is that the event
>row has been duplicated in the notify matching rule or if we are
>getting more events that we expected. We can also tell exactly which
>event row was matched to what subscription rows when you have events
>with no natural unique key and are doing a number of joins. This should
>help to clarify what the notify function has done in the match, and is
>it has done something odd.
>
>In a previous post on this topic the problem turned out to be
>unexpected behaviour from the sql event provider.
>
>i would be very interested to see the results...
>
>Kate MBCS
>
>Alert Technologies
>http://www.alert-technologies.co.uk
>Get your notification services implementation going in minutes not
>weeks ......

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