SQL Server Performance Forum – Threads Archive

linked table in sql 2000

hi,
I want to use a linked table in SQL 2000 but I don’t find. I have two db (db1 and db2) and some tables are the same. I want to share a table (table1), how can I do? So, db1.table1 is a real table. But db2.table1 is a virtual table or link. Is it impossible? thanks,
erkal

---

Are the databases on the same server or different ones? If they are on different ones you need to add the linked server first and then you can reference the second table as SERVER.DATABASE.OWNER.TABLE For the linked server the security context also has to be defined. Tom Pullen
DBA, Oxfam GB

---

thanks thomas, I forgot OWNER section.

---

]]>