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

Re: Disabled subscriptions still send messages....Help!

Subject: Re: Disabled subscriptions still send messages....Help!
From: Joe Webb
Date: Wed, 27 Sep 2006 13:30:40 -0500
Newsgroups: microsoft.public.sqlserver.notificationsvcs
In your match rule, you're joining to the subscription view, not the
underlying table, right? 



-- 
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 22 Sep 2006 12:16:20 -0700, [email protected] wrote:

>Our app goes through & disables some subscriptions using the NS views
>nightly based on some business rules.
>
>               UPDATE  Notify.dbo.NSSubscriptionClassView
>               SET             Enabled = 'Disabled'
>               WHERE   blah, blah, blah
>               AND             Enabled = 'Enabled'
>
>My problem is that these "disabled" subscriptions still seem to be
>generating matches & sending the messages out.  How/Why does this
>happen???  Where can I begin to debug why this is happening?  The
>underlying table beneath the view gets set properly when I update the
>view - I've looked at that.  An event matched with a disabled
>subscription should not be generating a notification!  Please help.

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