Microsoft SQL Server 2005 Developer’s Guide- P17:SQL Server 2005 is a feature-rich release that provides a host of new tools and technologies for the database developer. This book is written to help database developers and DBAs become productive immediately with the new features and capabilities found in SQL Server 2005. | Chapter 5 Developing with Notification Services 139 2005 s efficient relational database engine to join the rows from the events table with the rows in the subscriptions table in order to match events to subscriptions. Developing Notification Services Applications In the first part of this chapter you got an overview of the new SQL Server 2005 Notification Services. In this next section you learn about the actual steps required to develop SQL Server 2005 Notification Services applications. First you ll see a quick overview of the development process and next we ll dive in and build a sample Notification Services application. The process for developing Notification Services applications begins with defining the rules that govern how the application works. Next you must compile the application. Then you need to construct an interface that allows the user to add subscriptions to the application. Finally you ll need to add any custom components that may be needed by the application. Let s look at each of these steps in more detail. Defining the Application The Notification Services developer uses a combination of XML and T-SQL to define the application s schema and rules. When you define the schema and the rules for a Notification Services application you are essentially describing the events that the application will monitor as well as the application s subscriptions its notifications and the logic that will be used to match the events to the subscriptions. The Notification Services application s rules are primarily defined in two files an application definition file and an instance configuration file. Although you can also define them using the Notification Management Objects NMO API interface the application definition file and the instance configuration file are typically created using a standard text editor or an XML-aware editor such as Visual Studio 2005 or XMLSpy. More detailed information about the specific contents of the application definition file and the .
