Expert: Ashley Brazier Date: 3/14/2008 Subject: Using another db's tables
Question Hello Ashley
I have 2 separated SQL server databases on 2 machines: db1 on computer1 and db2 on computer2.
I want to make a view on db1 that uses 2 databases. For example:
SELECT * FROM DB1.TABLE1, DB2.TABLE2
How can I do that? I tried using IP addresses, but it failed. It seems that I don’t have any access to other databases tables.
Is there any way? Can you please help me?
Thank you. Azar
Answer Hi,
Do you have login details for both databases?
If you do you can set up a DTA data transformation package on DB1 and schedule the package to run at certain times, this will then copy the data from db2 to db1 and then you can use join statement to join the tables.
