Notification Service

[Elbino]

I need to create a notification service for my app. The app uses sql server 2008 and the client is WPF using the PRISM framework.

When some specific changes occur in the DB, like a user making changes to a particular table, I want to notify all active users of the app in the intranet of this change via a flag or something in the app, not email.

I am looking for suggestions on how to go about this

[Arjay]

I would create a windows service that polls the database for changes. Then I would use a WCF service to communicate with the client apps. WCF offers dual binding so you can send notification event to the clients (rather than having the clients poll WCF).


Btw, in Sql 2005 MS offered notification services but didn't support it in 2008. I was pretty excited about it at first, but found it to be lunky at best. Maybe that's why they dropped support for it in 2008?