From: esquel@sommarskog.se   
      
    (rja.carnegie@gmail.com) writes:   
   > On Monday, 27 November 2017 10:56:34 UTC, Erland Sommarskog  wrote:   
   >> It becomes more intuitive if you stop to think in terms of "outer   
   >> transaction". A transaction is all there is. So the ROLLBACK will   
   >> roll back it all.   
   >>   
   >   
   > Either my own understanding is wrong, or you should say,   
   > "Do not think in terms of outer transaction" - because   
   > the phrase "stop to think" has a different meaning.   
      
   Please bear with me: English is not my native language.   
      
   > I think we are agreeing that a transaction starts when   
   > "BEGIN TRAN" first appears - or automatically if a certain   
   > setting is in place (which I've forgotten)   
      
   SET IMPLICIT_TRANSACTIONS ON   
      
   > Also, we should avoid having long transactions: they block   
   > other business and (with simple recovery) they bloat the   
   > log file.  But if it's your own server then do whatever   
   > you want!   
      
   Our transactions should be as long as needed to complete the atomic   
   piece of work we want to do, not shorter.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)