I have an interface where i get a basic notification from Database A (SQl 2005) , based on which i select data from Database A and Database B (As400).
I also have to update a procees indicator in the transaction table of Database A.
What Transaction Type should i use for the connections to database A and database B?
If I use Local_Transaction for both database A and database B, it would mean i would have to use explicit trasactions.
Is there a way to avoid this?
Thanks in advance,