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.