I got two same database in one SQL server, named (Data_branch_usa,
Data_branch_uk)
Now, as the user login the system, I will let the user choose which database
they want to enter.
I wonder,I should use a table to store the branch information or use XML to
store it.
I really got no idea about it.
I know how to use third database to store the branchid, databasename, Ip
address, userid , password.
However, for XML, Can I do the simlar approach ???

Thanks

Agnes,

All those approaches that you tell can work. In the way you describe it (we
are talking about the connection String) would I set the name of the
prefered server (not the connectionstring) in the registry.

Just my idea

Cor