How to relate 2 different databases?

[miejan]

How to call for update for one field e.g. 'ID' if we have 2 different databases that having different table name but same field name which is 'ID' ? If we want to update for field ID in table 1 database 1, then it should update for field ID table 2 database 2 as well..need help on this!! :(

[michael_hk]

I can think of two ways

 

1. Application level: Code your app. to update both DB using COM+

2. DB level: Use replication

[travisowens]

Perhaps you should call a Stored Procedure to do this for you.

[HJB417]

that or a trigger.