Re: Duplicate Notifications
Based on what we see in the profiler:
Within one quantum:
NSMaterializeMyEventEventViews is started and completed in the
The MyEventEvents table contains unique events.
No single subscriber has more than one subscription with the same
Criteria matching the e.Criteria = s.Criteria constraint in the rule
NSFire2 is only getting called once.
insert into MyEventNotificationNotifications via sp_execute is
definitely getting called multiple times with the same data.
likewise NSMyEventNotificationNotify appears to be getting called too
Is there some scenerio underwhich the NSCurrentMyEventEvents table
could get populated twice ?
I can privately provide the relevant portions of the trace if that
would be helpful.