inserting record , table level lock 
Author Message
 inserting record , table level lock

we want to insert a record in a sql server table

the insertion is in a transaction

after the insert .the recordset is updated. the whole
table gets locked.
the transaction ends much later after some processing.
Other applications using the same table have to wait till
the transaction gets over.
is there some way to have just have a row level lock
instead of table level locking while
inserting.This would let other users open recordsets on
the table to read ,
and update.

Fri, 03 Sep 2004 22:28:02 GMT  
 [ 1 post ] 

 Relevant Pages 

1. record locking while insert new record??

2. Access 97 Row-Level Record Locking

3. Record-level locking

4. Record Level Locking Possible with Access?

5. Workaround for the Lack of Record-Level Locking

6. Record-level locking?

7. Jet 4.0 record-level locking?

8. How to do record/row level locking?

9. record level locking (access 2002)

10. Record-level locking?

11. Record Level Locking

12. How to do record/row level locking


Powered by phpBB® Forum Software