FIX: “Cannot use SAVE TRANSACTION within a distributed transaction” error when you execute a stored procedure in SQL Server

Applies to: SQL Server 2016 DeveloperSQL Server 2016 EnterpriseSQL Server 2016 Enterprise Core More

Symptoms


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:

Resolution


This issue is fixed in the following cumulative update for SQL Server:

Cumulative Update 7 for SQL Server 2017       

Cumulative Update 1 for SQL Server 2016 SP2

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the terminology Microsoft uses to describe software updates.