Is there any way to link a table of another database in SQL Server? (as in MS Access). If so, how?
Printable View
Is there any way to link a table of another database in SQL Server? (as in MS Access). If so, how?
Haven't work with SQLsvr long time, but try this one:
SELECT a.field1, b.field1
FROM firstdbname.tablename a, seconddb.tablename b
WHERE a.linkfield=b.linkfield
In INFORMIX you need the two DB to be in same states (loged ...)
Good luck
Expanding vbzen's comment, create a view in the first db for the table in the second and, of course, set the appropriate r&p. Just a thought.
Sincerely, I didn't understand either of them. However a Friend of mine told me to copy the table in the other database and set a DTS to keep it updated. Is this better solution than yours? If not, please explain me better.