101 votesDan commented
Same issue. Last week I applied SQL 2016 SP2 to both nodes of an AG. I have a database that was once performing trans. repl. and this has been removed. As a result we have 2x CDC SQL jobs (capture & cleanup). The capture job was showing this error message:
Executed as user: domain\user. Cannot promote the transaction to a distributed transaction because there is an active save point in this transaction. [SQLSTATE 42000] (Error 3933)
The other major consequence was the transaction log had grown considerably and could not be shrunk. The affected DB was showing [REPLICATION] in the log_reuse_wait_desc as per this article by Paul Randal:
I removed option 'per database DTC support', was then able to run this command:
EXEC sys.sp_removedbreplication 'DBName';
The capture job is now working as expected & I was able to bring the log file back to normal size.
FYI - I cannot enable the option [per database DTC support] the capture job immediately starts to output the same error as shown aboveDan supported this idea ·