Service Broker goodies: Cross Server Many to One (One to Many) scenario and How to troubleshoot it
I've written two more articles on SQLTeam about Service Broker.
The first one shows how to deploy a One to Many scenario over multiple servers. I've shown how to implement auditing from many child servers to one central storage server that holds all data. This is also applicable in a reverse situation of One to Many
The second one explains how and where to start looking when you have to troubleshoot and debug it.
Go and have a read.
Service broker is fun stuff!
