If you are on SQL 2008 these should work for you. Be sure to enable ad-hoc distributed queries. This brings in the entire DB, and you just query the tables you want. If this is not what your after, can you provide more info?

These are found at http://msdn.microsoft.com/en-us/library/ms190479.aspx

-LD

Native Client --

EXEC sp_addlinkedser ver
@server='S1_ins tance1',
...

Which versions of SQL are the databases? I infer from your question that they will all be the same Vendor and Versions. If this is incorrect, please include that info as well. Also, how much data are we talking about here, and are you using any constraints within the DB?

Thanks,
LD

I originally posted this on the MSDN forums and it did not get much traction so I will ask the question here.

I have an application that uses SQLExpress locally installed. When I am on domain, I can connect to it and use it with my domain account just fine. Everything works. If I am off Domain and log in with a cached account, I am unable to connect to the Database with scripts or applications, but I can connect just fine with SQL...