Export (0) Print
Expand All
1 out of 3 rated this helpful - Rate this topic

MOVE CONVERSATION (Transact-SQL)

Moves a conversation to a different conversation group.

Topic link icon Transact-SQL Syntax Conventions

MOVE CONVERSATION conversation_handle
   TO conversation_group_id
[ ; ]
conversation_handle

Is a variable or constant containing the conversation handle of the conversation to be moved. conversation_handle must be of type uniqueidentifier.

TO conversation_group_id

Is a variable or constant containing the identifier of the conversation group where the conversation is to be moved. conversation_group_id must be of type uniqueidentifier.

The MOVE CONVERSATION statement moves the conversation specified by conversation_handle to the conversation group identified by conversation_group_id. Dialogs can be only be redirected between conversation groups that are associated with the same queue.

Important note Important

If the MOVE CONVERSATION statement is not the first statement in a batch or stored procedure, the preceding statement must be terminated with a semicolon (;), the Transact-SQL statement terminator.

The MOVE CONVERSATION statement locks the conversation group associated with conversation_handle and the conversation group specified by conversation_group_id until the transaction containing the statement commits or rolls back.

MOVE CONVERSATION is not valid in a user-defined function.

To move a conversation, the current user must be the owner of the conversation and the conversation group, or be a member of the sysadmin fixed server role, or be a member of the db_owner fixed database role.

The following example moves a conversation to a different conversation group.

DECLARE @conversation_handle UNIQUEIDENTIFIER,
        @conversation_group_id UNIQUEIDENTIFIER ;

SET @conversation_handle =
    <retrieve conversation handle from database> ;
SET @conversation_group_id =
    <retrieve conversation group ID from database> ;

MOVE CONVERSATION @conversation_handle TO @conversation_group_id ;
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.