0

I have a requirement to perform some action and if something goes wrong I want all my data which was changed via multiple API to get reverted back so is there any way to Set the Transaction scope to complete DB such that Begin transaction is set at the first API and later on the 10th API or so I would either commit my changes or rollback

is this possible in SQL server to set Transaction scope kind of thing on the entire database

ksk
  • 165
  • 14
  • 1
    What you likely want is a distributed transaction, such as discussed in this question: [How do distributed transactions behave with multiple connections to the same DB in a threaded environment?](https://stackoverflow.com/questions/2186698/how-do-distributed-transactions-behave-with-multiple-connections-to-the-same-db) – Thom A Nov 24 '22 at 09:51

0 Answers0