How can i add the same value in to the different tables that are in different databases

Question

I am having 2 databases namely ach and cart and i am having tables namelt Register and Invoice i would like to add a field in to those 2 tables . Like if i enter a value like some ccyyxxyxyxa this should be saved in the 2 tables...

Answer 1

If there form one transaction then you can either use MSDTC or another option can be of Linked Servers in SQL

Answer 2

2 options , you can either insert/update same value from your code(c#) or write a trigger on one database that will insert/update the field on other database.