• Might help if you were to explain what you're doing. using service broker to send dynamic SQL is a truly strange way to use it.

    I can't tell if you're trying to process multiple messages as the same time to insert into the same table, but that's usually not done by sending SQL statements (you'd usually be sending a message payload, and the message content would be getting stored into the table, NOT sending SQL statements and having them execute).

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?