Hi Yelena,

I apologies for the delay in the response.

For your first comment, the GRANT statement is not case-sensitive, however the Service Broker's service names, contract names and message type names are case-sensitive. Service Broker is designed to let services in instances with different collation configuration communicate easily and effectively. The database that hosts a service that sends a message might not use the same collation as the database that hosts the service that receives the message. To overcome the barrier of different collations, the Service Broker uses a byte-by-byte comparision to match the service names, contract names, and message type names.

For you second comment, it would be great if you could provide more information. Could you also let me know the the owner of the Service Broker objects created. Is is 'dbo'?

For you third comment regarding error messages, say a conversion between two services fails for some reason. The program may require a compensation transaction or require to record the error occurred or require both or require none. Based on the requirement the program peforms a compensation transaction or logs the error to a logging table (ErrorTable for example) or does both or does nothing and ends the conversation.

HTH.

Regards,

Sachin