Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Moves a conversation to a different conversation group.
Syntax
MOVE CONVERSATION conversation_handle
TO conversation_group_id
[ ; ]
Arguments
- conversation_handle
Is a variable or constant containing the conversation handle of the conversation to be moved. The 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. The conversation_group_id must be of type uniqueidentifier.
Remarks
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
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.
Permissions
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.
Examples
A. Moving a conversation
This 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 ;
See Also
Reference
BEGIN DIALOG CONVERSATION (Transact-SQL)
GET CONVERSATION GROUP (Transact-SQL)
END CONVERSATION (Transact-SQL)
sys.conversation_groups (Transact-SQL)
sys.conversation_endpoints (Transact-SQL)