-- Tested with SQL Server 2005 9.00.852
-- Ends a dialog conversation.
-- This is a Service Broker feature.
DECLARE @DialogHandle UNIQUEIDENTIFIER;
BEGIN DIALOG @DialogHandle
	FROM SERVICE DotNetFunService
	TO SERVICE 'DotNetFunService'
	ON CONTRACT DotNetFunContractSentByAny;
SEND ON CONVERSATION @DialogHandle 
	MESSAGE TYPE [DotNetFunMessageTypeValidateNone]
	('HELLO!');
/*
NOTE: It's not necessary to explicitly end a conversation.
The primary purpose of ending a conversation  
is to prevent any further messages from being added to the 
same conversation group. Another message will be added to the 
queue if you do explicitly end the conversation and it will 
have an activation of 'E' for 'End' and an mesage type of 
'http://schemas.microsoft.com/SQL/ServiceBroker/EndDialog'.
After an END CONVERSATION is performed, any other messages 
belonging to the Message Group will not be allowed to send 
messages on that group accordingly.
*/
END CONVERSATION @DialogHandle;