sql server notification services: I've built a simple app using the SongAlert sample from the book as my
reference. I wrote a fairly simple custom formatter and am trying to debug
it. Based on my logging and debugging, I can see that the Initialize() and
Close() events on my formatter are getting called, but it never calls
FormatContent() in between. I can see the Events and Notifications in the
database. I'm using the File provider, and I get a file output, but it is
empty. It's like it finds the Notifications it needs to send, but doesn't
even attempt to deliver them. I've been looking at this problem for about
3 days now, and I'm kind of at a loss... Any ideas?

Thanks in advance,

Scott,
In the Notifications table NS<NotificationClassName>Notifications, there are
columns for SubscriberID and DeviceName. Are you certain that, for the
notifications you're looking at, the [SubscriberId, DeviceName] pair matches
a valid record in the NSSubscriberDevices table in the Instance
(<InstanceName>NSMain) database?

If your notifications have invalid subscriber device names, the distributor
will simply do nothing with them. We have fixed the distributor in the next
release to log a warning message when it finds notifications like this.

Thanks
-shyam

--
Learn more about SQL-NS:
http://www.amazon.com/exec/obidos/tg/detail/-/0672326647/
---------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
---------------------------------------------
[quoted text, click to view]

[quoted text, click to view]

That was it! Thank you very much... you got my project back on track!