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

Re: Inconsistent Double Notifications

Subject: Re: Inconsistent Double Notifications
From:
Date: 17 Oct 2005 10:04:07 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
We are saving similiar, dupe issues in a clustered environment.
I am able to track down the condition but have no fix yet.

When there are 2 URL and Msgs (The 2nd and 3rd unique arguments) that
are identical, we get duplicate entries sent to subscribers even though
the EmailAddress is different in both rows.
This function works fine as a standalone and there are only 2 rows
generated but each email address gets dupes for the same message.
If there is a single unique url/msg to an email, there are no dupes.

Ideas?

                                        
<RuleName>AreaAlertsSubscriptionsRule</RuleName>
                                        <Action>
                                                SELECT 
dbo.FooNotificationsNotify('aSubscriber', 'aDevice',
'en-US', EmailAddress, URL, Msg)
                                                FROM SPS_CONTENT.dbo.Foo
                                        </Action>


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