Home > Archive > MS SQL Server ODBC > May 2005 > Excessive locking









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Excessive locking
stquestions

2005-05-11, 11:23 am

Hello,

it looks that Microsoft SQL Server 2000 - 8.00.760 table with
autoincrement field is locked (even for read) between any insert and commit
in manual commit mode.
The same code works with Postgres just fine.

The isolation level is the default one.

Any suggestions?
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com