Transaction management has savepoints and nested statement restrictions.
Restrictions on transaction management are:
Savepoints are not propagated to remote servers.
If nested BEGIN TRANSACTION and COMMIT TRANSACTION statements are included in a transaction that involves remote servers, only the outermost set of statements is processed. The inconsistent set, containing the BEGIN TRANSACTION and COMMIT TRANSACTION statements, is not transmitted to remote servers.