Readme_EventLogging Sample

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

The EventLogging sample provides a simple application that registers for, receives, and archives event notification messages.

Scenario

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

  1. Open the project file in SQL Server Management Studio.

  2. Run the scripts, in order:

    1. Set up Event Logging Service.sql.
    2. Test Event Logging.sql.
    3. Clean up Sample.sql.

See Also

Other Resources

Developer's Guide (Service Broker)

Help and Information

Getting SQL Server 2008 R2 Assistance