PHISSUG

Home of Filipino Sql Server Enthusiasts
Welcome to PHISSUG Sign in | Join | Help
in Search

Notification Services components

Last post 12-13-2007, 12:18 AM by bass_player. 2 replies.
Sort Posts: Previous Next
  •  12-10-2007, 10:18 PM 2224

    Notification Services components

    Notification Services is a cool new feature in SQL Server 2005 that enables a subscriber to receive notifications using their PDA's, Cellphone, email or through text file when a specific event occurs.

    In notification services, we have a file known as Configuration file and the Application Definition file, which is used to configure notification services, which by the way is an XML file. The configuration file contains the settings for an instance of the notification services and the ADF (Application Definition File) contains the setting for individual application in an instance of Notification services.

     Next we have events. Events are anything that a user might want to be notified about. For example an updated score of NBA games per quarter. the stock prices, flight schedules, etc. An event provider will submit event to the notification services that will store event information on the database table.

     Subscriber are users who receive the notification of a particular event that occurs.The subscription stores the information about the subscriber and the event they wished to be notified of.

     

    Last is the distributor. The distributor formats the appropriately and sends it to the devices specified by the Subscriber. 


     


    MCP.MCAD.MCDBA.MCTS:SQL Server 2005.MCITP:SQL Server 2005 Database Administrator.MCT
  •  12-11-2007, 8:11 PM 2230 in reply to 2224

    Re: Notification Services components

    Ive heard that Nofication Services is no longer part of SQL server 2008 components. Can anyone confirm this?

  •  12-13-2007, 12:18 AM 2238 in reply to 2230

    Re: Notification Services components

    This feature will be deprecated in SQL Server 2008
View as RSS news feed in XML
Powered by Community Server (Personal Edition), by Telligent Systems