CODEWITHSUNDEEP
sql-serversql-server-2008service-broker
Dugan
Dugan

Reputation: 918

In Sql Service Broker, is it possible to create a dialog with specific conversation_handle

I'm using Service Broker as a messaging queue for a job engine. When the jobs are created they are given a Guid that is used by the system to track the progress of a job. Given that, would it be possible to create a dialog in Service Broker that uses a given Guid instead of creating it's own?

Upvotes: 1

Views: 154

Answers (3)

Tom Wilson
Tom Wilson

Reputation: 551

You can specifiy a RELATED_CONVERSATION_GROUP (a GUID) when you do BEGIN DIALOG. A conversation group is just made up and tracked by your application, and you can receive messages for that conversation group or see what conversation group a received message belongs to.

Upvotes: 1

Damien_The_Unbeliever
Damien_The_Unbeliever

Reputation: 239794

As @RBarryYoung says, no, you cannot.

Could you turn the question on it's head? Could you delay needing a job Guid until you start a dialog, and then use the returned conversation handle as the job Guid?

Upvotes: 0

RBarryYoung
RBarryYoung

Reputation: 56755

No, conversation_handles are created for you, you cannot specify them.

Upvotes: 0

Related Questions