Archive for the ‘service broker’ Category

Service Broker Across 2 instances on the same machine

May 31, 2012

Not that much more difficult than across 2 databases on the same instance.

Ive attached 6 files in a single .zip file 2 instances.zip

Advertisements

Service Broker Across two databases on the same instance

May 29, 2012

This post modifies the project contained in Service Broker with In a Single database by splitting the conversation out to 2 databases within the same instance. The rest of the functionality remains the same.

service_broker_across_db.sql

Service Broker In A Single Database

May 29, 2012

This post demonstrates how Service Broker can work within a single database. The example here demonstrates a conversationĀ initiatorĀ sending a message to the target, the target stores the message text in a table then the conversation is closed.

service_broker_single_database.sql