Re: How can I use Notification Services to notify my applications
Query Notifications will be good if the data you need to monitor can
take an indexed view (which is what drives QN). If the data won't (and
their are lots of conditions that rule out indexed views) then using
NS would be a good choice. To deliver to your app you use the same
mechanics an QN but set up a custom version. The QN delivery is via
Service Broker which allows your app instance to subscribe to a service
broker queue to raise an event when their is a new message. In this
case the message will be the revised data that you NS service has
dropped into the queue.
so you would need to read up on Service broker and creating an
sqlclient sqldependancy in your .net app. try the Rational guide to SB.
hope that helps