The EventLogging sample provides a simple application that registers for, receives, and archives event notification messages.
The EventLogging sample includes a simple implementation for a service that receives and archives event notification messages. For demonstration purposes, the sample stores event notifications in two different tables. Each table uses a different format. One table stores the data from the event notification in relational format. The other table stores some information from the event notification in relational format, while storing the complete message as XML.
Running the Sample
To install and run the sample
- Open the project file in SQL Server Management Studio.
- Run the scripts, in order:
- Set up Event Logging Service.sql.
- Test Event Logging.sql.
- Clean up Sample.sql.
Developer's Guide (Service Broker)
Help and Information
- Getting SQL Server 2008 Assistance* © 2008 Microsoft Corporation. All rights reserved.