Linking Databases

[dom24]

Could someone tell me how I link between tables in 2 different databases? I'm using SQL server 7 for both databases.

Thanks,

 

[JayKusch]

SELECT *
FROM Database1.dbo.Table1 as t1
JOIN Database2.dbo.Table2 as t2
ON (t1.ID = t2.ID)

ID used above would be the field(s) you are linking/joining the tables on.


Thanks

J. Kusch

 

[dom24]

No sorry, I want to link them using constraints or something so that when one table is updated the other works from the new data.
I have a staff table in an evaluation database, then a booking table in a room booking database and I want to link the 2 tables on staffno.

 

[JayKusch]

The you are probably looking for a trigger. Though cross database operations are not fun or encouraged.

Thanks

J. Kusch