• TryingToLearn (10/25/2016)


    i need to create a queue via a trigger(i'm assuming) that will be consumed by a service/event bus in RabbitMQ. Would MSMQ be the proper way to proceed?

    We already use RabbitMQ processing queues on the Oracle side and now we are finding it would helpful to get some SQL notifications in the same manner.

    Before i begin testing this i was hoping to go in the proper directions.

    Thanks.

    You might be looking for "Service Broker" in SQL Server. Never heard of MSMQ before.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)