README.TXT FILE FOR THE "SERVICE BROKER QUARTET"

This file unzips to create a c:\ServiceBroker folder with subfolders for three Service Broker-related objects.

Prerequisites:

1. Visual Studio 2005 Standard Edition or Visual Basic Express 
2. SQL Server 2005 Express or higher (SQL Server 2005 Developer Edition or higher is recommended to enable viewing Service Broker database objects with SQL Server Management Studio's Object Explorer)
3. SQL Server 2005 Service Pack 1 (SP 1) Community Technical Preview (CTP) or release version is recommended for SQL Server 2005 and SQL Express
4. Northwind sample database installed
5. Northiwind database compatibility level = 90 and Service Broker enabled (see below)
6. A login with sysadmin privileges (preferably the owner of the Northwind database)

See http://oakleafblog.blogspot.com/2006/04/running-query-notifications-sample.html for more details.

*** BE SURE TO MARK THE USE FOLDER NAMES CHECK BOX WHEN UNZIPPING ***

C:\ServiceBroker\SimpleSSBScripts\SimpleServiceBroker.ssmssln is an SQL Server Management Studio project that creates an initiator and target service in the Northwind sample database. 

Run the following scripts in sequence:
  1. CreateSSBObjects.sql (this script)
  2. SendSSBMessage.sql (sends a message to the NwindTargetQueue
     Repeated executions enqueue multiple conversation groups
  3. ReceiveSSBMessage.sql (reads and displays message(s) from the NwindTargetQueue

Run DropSSBObjects.sql to clean up.

C:\ServiceBroker\InitiatorTargetScripts\InitiatorTargetSSB.ssmssln is a similar project that sends messages between two databases on the same SQL Server instance.

Run the following scripts in sequence:
  1. CreateInitiatorAndTargetDBs.sql
  2, SendMessageToTarget.sql

Run DropInitiatorAndTargetDBs.sql to clean up.

C:\ServiceBroker\EventLogging\EventLogging.ssmssln is a minor variation on the SQL Server 2005 Database Engine Service Broker samples. Run the three scripts in numeric sequence.

C:\ServiceBroker\QueryNotifications\QueryNotifications.sln is a Visual Basic 2005 project that demonstrates how to write VB and T-SQL code to manage SQL Server 2005 Query notifications. For illustrated operating instructions, see http://oakleafblog.blogspot.com/2006/04/running-query-notifications-sample.html.

Questions and comments to Roger_Jennings@compuserve.com
