Free Training and Career help

In this tutorial you will learn about using notification services in SQL Server 2005, Notification Services Architecture, Building Notification Services Solutions, Using Notification Services, Subscription Management, Syntax for adding subscribers, Syntax for adding a device, Syntax for Adding the Subscriptions.

Notification Services Architecture
Building Notification Services Solutions


This new feature of SQL Server 2005 is directed towards the delivery of event driven or scheduled notifications to users who have opted to receive such notifications. Developers find this feature extremely useful for developing and deploying applications that require notifications to be sent to users based on subscriptions made by them.

The most significant feature of this service is that information can be scheduled to be sent to the user at timed intervals to their computers or mobile devices in response to the occurrence of a predefined event. The event could be the delay of a flight or the reduction of stock below a specified level.

The notification services model is based on the Subscriber/ subscription scenario with some enhancements in that the response to each subscription can be customized. A subscriber is one who has requested for the notification to be sent to him on a specified device or devices. An event is a trigger that shoots out the notification to the subscriber. A notification is the customized message that is shot out to the subscriber when the predefined event has occurred.

Read More...

http://www.exforsys.com/content/view/1733/356/