SQL Server's Notification Services let you instruct the database to let your applications or your users know when data changes or reaches critical thresholds. Furthermore, standard notification delivery methods ensure that notifications aren't limited to .NET or Windows clients.
by Laurence Moroney
May 19, 2005
tarting with SQL Server 2000, Microsoft added the concept of notification services to their flagship database engine. SQL Server Notification Services lets you generate and send notifications whenever some criterion is met. Generally, you use notifications to alert or update data for users or applications without having to repeatedly poll the database to discover whether data has changed or to display the latest data. For example, if you follow fantasy sports, it would be nice to have a notification service that informs you when your star player is injured. Alternatively, if you prefer the stock market, you may want to be notified when a stock you own reaches a particular price on the upward or downward curve!
With SQL Server 2005, you can generate notifications and have the SQL Server distributor send those notifications in any of several ways:
On a file channel, where a file is written to a specific directory with the contents of the notification.
On an SMTP channel where SQL Server e-mails the notification.
On an HTTP channel, which can be customized to deliver the notification in a number of ways, such as a SOAP message or HTTP POST of the notification to a server.
In this article you'll see how to set up Notification Services within SQL Server 2005, learn how to deploy and use the Stock Quote notification service and finally, how to take advantage of notifications with Java.
It's quick, easy and you get access to all the articles on DevX.
This registration/login is to allow you to read articles on devx.com. Already a member?
To become a member of DevX.com create your Member Profile by completing the form below. Membership is free!
tarting with SQL Server 2000, Microsoft added the concept of notification services to their flagship database engine. SQL Server Notification Services lets you generate and send notifications whenever some criterion is met. Generally, you use notifications to alert or update data for users or applications without having to repeatedly poll the database to discover whether data has changed or to display the latest data. For example, if you follow fantasy sports, it would be nice to have a notification service that informs you when your star player is injured. Alternatively, if you prefer the stock market, you may want to be notified when a stock you own reaches a particular price on the upward or downward curve!
