My error.

I should have included the entire procedure:

CREATE PROCEDURE [dbo].[ProcessLogQueue]

AS

BEGIN

SET NOCOUNT ON;

BEGIN TRANSACTION

WAITFOR (RECEIVE TOP(1)

CONVERT (XML, CONVERT (varchar(MAX), message_body) )

FROM

LogTargetQueue)

COMMIT TRANSACTION

END