suppose you will insert some data in a table from two other's table/data base. Begin Tran Use DataBase2 insert into Table1(Name,Id,Roll,Address) select A.Name,A.Id,B.Roll,B.Address from DataBase1..Table2 A inner join DataBase2..Table3 B on A.Id = B.Id Commit tran If You use this query then you will easily transaction (Insert) data from two different data base & tables.

Mrityunjoy Bhattacharjee

modified on Sunday, August 8, 2010 12:06 PM