Is it possible to run a Sql statement that links to tables in two separate Sql Server 2000 databases?<BR><BR>Both databases are held on the same server.<BR><BR>Thanks for any help.
Sure<BR>You need select ability on each DB<BR><BR>For each DB you need to reference fully i.e.<BR><BR>Northwind.dbo.Employees
Fantastic. I love you. You can have my kids!