home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 18,558 of 19,505   
   Tony to All   
   transaction   
   23 Jan 12 10:40:27   
   
   From: johansson.andersson@telia.com   
      
   Hello!   
      
   Here is a text in a book.   
   "To ensure that you don't leave your transaction open for too long, consider   
   using sqltransaction object in a Using block. The longer the transaction   
   remain open, the longer the database needs to maintain the locks for the   
   rows. If the SqlTransaction has not been committed or rolled back at the end   
   of the using block, the Rollback is called implicitly."   
      
   The text mentioned maintain the locks for the rows. Does this mean that   
   those rows that are included in the transaction is locked so that other   
   users can't access these neither by select them or some other DML action   
   query ?   
      
   //Tony   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca