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?