I would like to set a SQL broker service whereby DatabaseA sends the same data to DatabaseB and DatabaseC. In this case, all databases reside on the same instance.
I have looked at the following examples, however, they only show me how to setup a SQL broker service between two databases:
- Conversation between Databases in SQL Server - Service Broker
- Setup service broker between two databases in SQL Server
I would be grateful if anyone could provide any assistance on this.