Using SQL 2005 or 2008, is it possible to create a database called C that is a view into all tables in database A + B ? Databases A, B, and C are on the same local server.
I am wanting to be able to create join queries between tables that are in 2 different databases. Is there another way to do this?
You can create DatabaseC if you want to, but it adds no value. Just use 3 part object names:
SELECT A.col1, B.col2 FROM DatabaseA.dbo.TableA A JOIN DatabaseB.dbo.TableB B ON A.xx = B.xx