Learn more about Toad for SQL Server
at Quest.com

Find solutions and downloads at the
Toad for SQL Server Support Portal

< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7

You are here: Manage Administration Tasks > Configure Service Broker Communications > Manage Service Broker Objects > About Conversations

About Conversations

The Conversations window displays information about conversations currently in progress.

The top pane displays the conversations in which the current endpoint is taking part. The icon beside each conversation indicates the current status of the conversation:

Icon	Conversation Status
	STARTED_OUTBOUND STARTED_INBOUND
	CONVERSING
	DISCONNECTED_INBOUND DISCONNECTED_OUTBOUND
	ERROR
	CLOSED

Select a conversation to display a list of the messages sent as part of that conversation in the bottom pane.

To start a conversation

Expand the Service Broker tree for the database initiating the conversation.
Right-click the Conversations node and select Create.
Set the conversation properties.

To send a message

Right-click the conversation partner to use from the list of conversations, and select Send Message.
Enter the contents of the message. This should conform to the contents expected by the Message Type.
Click Send.

To view the contents of a message

Right-click the message and select Show Message.

To assign a conversation to a different conversation group

Rght-click the conversation and select Edit.
Select the new conversation group to associate this conversation with.

To end a conversation

Right-click the conversation and select End Conversation.
Specify the End Conversation options.