You nee dto inset a message in a queue and execute the following statements, but for some reason the message was not submitted to the queue. Identify the problem.
declare @ message xmldeclare @ converstionhandle UNIQUEIDENTIFIER
set @message = ‘<TICKETREQUEST>
<Requestor>student@training.com</Requestor>
<Requestednumber>5</Reqesutednumber>
<RequestedShow>SQL Server Traiing</RequestedShow></TICKETREQUEST>’
BEGIN DIALOG CONVERSATION @conversationHandle
FROM SERVICE ‘ReceiveTicketingService’
ON CONTRACT TicketServicesContract
WITH ENCRYPTION = OFF;
END CONVERSATION @conversationHandle
- - End the conversation.
Answer: – You forgot to send the message on the conversation.
(You submit a message to the queue using a SEND message:
SEND ON CONVERSATION @conversationHandle MESSAGE TYPE TicketRequest (@message);)