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