Starting a new app that will be drawing data from two databases, both db's will be Sql Server 2005. At the moment both dbs are also on the same server but would like to leave some flexibility of this possibly changing in the future.
For the most part, data drawn from the one database will be...