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

Re: Event View does not return Events while NSEvent Table has rows

Subject: Re: Event View does not return Events while NSEvent Table has rows
From: Joe Webb
Date: Wed, 15 Aug 2007 04:19:26 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
On Tue, 14 Aug 2007 18:09:26 +0000, TechJunkie wrote:

> Dear group ,
> my subscription rule  uses View Names for both the Subscription and
> Event Tables.
> Even though the NSSubscription and NSEventClass tables have data, the
> rule does not find any rows using the views. After looking at the
> NSCurrentTables there are no rows being added here.
> Thus I am unable to get Notifications in the Notification View \Table.
> Please help me with this
> 
> Thanks,
> Junkie


The NSCurrentTables are populated as needed with quantum data so you won't
see rows there outside of the quantum. 

Can you post your match rule for us to review?

Thanks!

Joe


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

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