Welcome to

SqlServer-QA.net

Sign in | Join | Help

SQL Server Storage Engine & Tools (SSQA.net)

SQL Server Tools includes storage engine that includes a complete set of graphical tools and command prompt utilities that allow users, programmers, and administrators. SSMS, SSRS, SSIS & SSAS are most commonly used tools.
Learn about Notification Services - a tutorial

The Notification Services tutorial teaches you how to build a simple Notification Services application. The tutorial uses a SQL Server Management Studio solution to make it easy to edit tutorial files and then build the solution using SQL Server Management Studio Object Explorer.

Before you start the tutorial, you should be familiar with Notification Services concepts and terminology. To learn about Notification Services, see Introducing SQL Server Notification Services.

This tutorial is intended to be used on a single computer that has all the required software installed. Make sure that you have done the following:

  • You have installed the Database Engine, Notification Services, and Workstation Components. For more information, see Installing SQL Server 2005.
  • You have installed the Notification Services samples. For more information, see Installing Samples.

You have started an instance of the Database Engine. For more information, see Starting and Restarting Services.

This tutorial is divided into 11 lessons. You must complete all tutorial lessons in order to develop a working Notification Services application.

Lesson 1: Opening and Examining the Tutorial Solution

In this lesson, you open the SQL Server Management Studio solution and examine the files in the solution.

Lesson 2: Performing an Initial Build of the Tutorial Instance

In this lesson, you review the application definition file (ADF) for the Weather application and the instance configuration file (ICF) for the Tutorial instance of Notification Services, and then perform an initial build of the instance and application.

Lesson 3: Adding an Event Class

In this lesson, you add an event class to the ADF that describes event data.

Lesson 4: Adding a Notification Class

In this lesson, you add a notification class to the ADF that describes notification data, formatting, and delivery.

Lesson 5: Adding a Subscription Class

In this lesson, you add a subscription class to the ADF that describes subscription data and the rules that generate notifications.

Lesson 6: Adding an Event Provider

In this lesson, you add a non-hosted event provider declaration to the ADF. This is used to identify events added using the event submission stored procedures.

Lesson 7: Configuring the Generator and Distributor

In this lesson, you specify where the application's generator and distributor run, and the polling interval for the distributor.

Lesson 8: Altering Application Execution Settings

In this lesson, you specify generator, distributor logging, and data removal settings.

Lesson 9: Registering, Enabling, and Starting the Instance

In this lesson, you register, enable, and start the instance of Notification Services.

Lesson 10: Adding Subscribers and Subscriptions

In this lesson, you add subscribers to the instance database and subscriptions to the application database.

Lesson 11: Submitting Events to the Weather Application

In this lesson, you add events to the application and then view the resulting notifications.

(the above is extracted from Technet, for some reason it doesn't show up when I link the same, hence I have copied important bits here)

Posted: Monday, July 23, 2007 5:44 AM by SQL Master

Comments

SSQA.net - SqlServer-QA.net said:

The Notification Services tutorial teaches you how to build a simple Notification Services application

# July 23, 2007 6:16 PM
Anonymous comments are disabled