I am a developer intern at Microsoft in the SQL Service Broker team. We like to think of Service Broker as a reliable messaging architecture for SQL server. Although the underlying mechanism of queues is currently visible to the application developer, we feel that queues are implementation details and not something the developer needs to think about while building a distributed application. Apart from that your description is quite accurate. We would like our customers to really understand the power of pushing the business logic for creating distributed applications into the server engine thus exploiting all the features of transactions, locking and in-proc execution.

Hi Rushi,

Thanks for your comment and I agree that a developer should not have to worry about the underlying implementation but I'm glad you have exposed it as it gives some nice hooks on which to build management and monitoring capability into our products. Please don't remove it for the RTM...

James.

Message we pass to service request is always in binary format then how we can send data of that binary xml into local tables means how to use @msgXMl.nodes and node(ref)

Hi Varinder,

I'm not sure what you are trying to describe. If the question is whether or not you can send binary messages via the service broker, then the answer is yes. The message can be any SQL type. If not, could you expand on your original comment?

Cheers,
James.