-- Tested with SQL Server 2005 9.00.852
-- Retrieves the next available set of 
-- dialog conversation messages from the queue.
USE DotNetFun;
DECLARE @InProcTable TABLE (
	conversation_handle UNIQUEIDENTIFIER, 
	message_body VARBINARY(MAX));
-- Insert each message body from each message into 
-- an in-memory table:
RECEIVE conversation_handle, message_body 
	FROM DotNetFun..DotNetFunQueue 
	INTO @InProcTable;
/*
NOTE: With RECEIVE, Service Broker retrieves 
messages one conversation group at a time.
*/