Distributed transactions vs general transactions

Premise: first create a linked server, alias: linkserver

Set xact_abort on/* This must be enabled, otherwise the transaction has no significance */

/* Haha, the most obvious sign of distributed transactions; a common transaction is Tran in TRAN T1; a common transaction here can be considered as a transaction on a server rather than a cross-server transaction, that is, narrow distribution */
Begin Distributed Transaction T1
Update linkserver. db1.dbo. Table1 set.../* update another remote server */

Insert into localhost. db2.dbo. Table2.../* append a record to the local server */
 
If @ error <> 0/* if there is an error, the transaction is rolled back. If there are multiple steps, the transaction can be rolled back in batches */
Begin
Rollback T1
Return @ Error
End
Commit tran