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.

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.

  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.

Community Additions