Restrictions on Transaction Management

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 innermost set, containing the begin transaction and commit transaction statements, is not transmitted to remote servers.