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
Change is inevitable... Change for the better is not.