I implemented a very similar solution a while back and find it works well. I also have a SSRS front end to view my data. The monitoring solution also grabs...

Sorted. Set Collation Compatible on the linked server on Server A and it's fine. Not sure why, as collations are exactly as they were before and it's not set on...

This article is not relevant. I don't get this error and I don't get to the stage where I'm running at distributed transaction.

I have since resolved the issue

I have a similar process which runs a sproc on each server which performs a LOAD HEADERONLY on each dump device which populates a central db with details of the...