Readme_EventLogging

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

By default, the EventLogging sample application is installed at C:\Program Files\Microsoft SQL Server\100\Samples\Engine\\ServiceBroker\EventLogging. If the sample folder is not present, see Installing Samples.

Samples are provided for educational purposes only. They are not intended to be used in a production environment and have not been tested in a production environment. Microsoft does not provide technical support for these samples. Sample applications and assemblies should not be connected to or used with your production SQL Server database or your report server without the permission of the system administrator.

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

Service Broker Programming

Help and Information

Getting SQL Server 2005 Assistance