Referencing two tables in different databases in the same stored proce

[rushdib]

Hi,
I have a stored procedure in database 1 to insert rows from table1 to table2. This insert statement uses a third table table3 which exist in database 2. How do I refer to that table inside the insert statement?
I am calling the procedure from Access using ADO connection with a connection string. Do I have to open database 2?

Thanks in advance,

Rushdi

 

[markVII]

No, you need a distributed query. The name of table must be fully qualified i.e. db_name.dbo.table_name.
Also make sure that DTC service is running.