We are running two side by side reporting servers, one as the live server and one as a failover. When a proc is created or altered on the live server the same should be done on the failover. Currently this is done by changing the connection from one server the to other and repeating whatever was done. What we'd like is some sort of fail-safe so if the change isn't made on the failover it is picked up and done automatically. I'll be able to write something that picks up those procs that have been created\altered on one server but not the other but I'd like some advice about how to go about scripting out the required procs and making the appropriate changes, if indeed that's possible. We may be able to go with third party tools but I think they may have to be a last resort. Any suggestions?
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