Home Forums Programming Service Broker Sequentially processing messages in Service Broker Queue RE: Sequentially processing messages in Service Broker Queue

  • ALTER QUEUE InstTargetQueue

    WITH ACTIVATION

    (

    STATUS = ON,

    PROCEDURE_NAME = usp_ExecutePackage,

    MAX_QUEUE_READERS = 20,

    EXECUTE AS 'dbo'

    );

    Do you mean to say i have to set MAX_QUEUE_READERS = 1 ? So that it will not invoke the Activation Proc if one instance is already executing???