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...
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...