Grasshopper. Thanks for your post!

I agree with your approach but I am starting to get a bit confused as to what my best set up should be.

My LIVE environment consists of 2 servers (A_Live and B_Live .... A_QA and B_QA).

Prior to your post, I have the XML file on each server pointing to a CONFIG table on the appropriate environment. This table will then set the connections based on their names and the Configuration_Filter field.

Are you suggesting that I do not use a SQL Server Configuration Table and strictly rely on Variables (varServerA and varServerB) to set the connections appropriately?

Sounds simple. I would just need an XML file on each server with the two variables with the appropriate values.