This is not intended as a generic script you can just copy, paste, and run and get results. It needs a little light editing to make it work in your environment.
The first element that needs changing is the database mapping (the common database identifier used in my script was "ODS" - and the full database names are, for example, [Acme_ODS_NewZealand], [Acme_ODS_Australia]). So you would need to change "ODS" to an common identifying word used in the databases in your environment.
The other element that needs changing is the naming pattern of the linked servers. The script uses "MASTER" and "SLAVE" to identify the linked servers used in our environments - and the full linked server names could be, for example, [YOGI_MASTER_BOOBOO], [YOGI_SLAVE01_BOOBOO], [YOGI_SLAVE02_BOOBOO]. so you need to edit the code replacing "MASTER" and "SLAVE" with patterns that match linked server names used in your environment.
BI Technical Lead
Clear Channel International