Export (0) Print
Expand All

MOVE CONVERSATION (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Moves a conversation to a different conversation group.

Applies to: SQL Server (SQL Server 2008 through current version).

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 ;
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft