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