10

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
Mitch Wheat
  • 295,962
  • 43
  • 465
  • 541
mehdi lotfi
  • 11,194
  • 18
  • 82
  • 128

1 Answers1

13

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.

Oskar
  • 7,945
  • 5
  • 36
  • 44
Mitch Wheat
  • 295,962
  • 43
  • 465
  • 541