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.