We have a live and failover Report Server and I'm currently in the process of making sure that all the reports and procs match across the two. The problem I've come across is that they do actually match exactly and I'm not sure that they should. I've been using Beyond Compare to compare them and I've discovered that in most cases, where I should have a difference there hasn't been one. Each piece of XML I've compared has had a short section and the bottom like so:
That has been the case for all the reports that I've checked on both servers. I was expecting that the XML on one server would have the URL for that server and the XML on the other would have the corresponding URL ie
Some of the reports have what I think is the correct URL but the majority of them don't. When I investigated the reports manually everything appeared correct and both versions ran on the appropriate servers. Can anybody shed any light on this please? If you need more information just ask.
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher How to post a question to get the most help