Assume that you create an Availability Group by using the WITH DTC_SUPPORT = PER_DB clause in Microsoft SQL Server. When you try to execute a SAVE TRANSACTION statement in a transaction to a single database that includes system stored procedures such as sp_executesql, you receive the following 627 error message:
Cannot use SAVE TRANSACTION within a distributed transaction.
Because the transaction will promote to Distributed Transaction Coordinator (DTC) which does not support SAVE TRANSACTION.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.