Cannot roll back TR1. No transaction or savepoint of that name was found.

 

在朝狀交易特別是層層包覆的SP十分容易遇到....

建議先不要特別為transaction 取名

一律都統一用

begin tran

commit tran

rollback tran

https://stackoverflow.com/questions/19260055/cannot-roll-back-subtransaction-no-transaction-or-savepoint-of-that-name-was-fo

https://www.sqlservercentral.com/forums/topic/transaction-no-transaction-or-savepoint-of-that-name-was-found

https://blog.sqlauthority.com/2015/03/11/sql-server-error-msg-6401-level-16-cannot-roll-back-transaction/