What's the different between Distributed database transaction and cross database transaction in SQL Server.
I know that Distribute database transaction is a transaction between multiple database and can use by following query :
BEGIN DISTRIBUTED TRANSACTION
...
COMMIT TRANSACTION
A Cross database transaction occurs between 2 or more databases on the same server. It does not require the involvement of a DTC (Distributed Transaction Coordinator)
A Distributed database transaction occurs between 2 or more databases hosted on multiple servers. DTC (Distributed Transaction Coordinator) services are required on each participating server.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With