|
|
|
|
||||||
| ms.sqlserver.setup Questions about SQL Server. |
![]() |
|
|
LinkBack | Outils de la discussion |
|
|
#1 |
|
Messages: n/a
Hébergeur: |
Hello,
sql server 2005 uses by default pesimistic locking during select execution. Is there any possibility in server setup to tell him to use optimistic locking? Thank you for your advice Tomas Vojtech |
|
|
|
#2 |
|
Messages: n/a
Hébergeur: |
I suggest you check out below Books Online section:
ms-://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/1d7972a0-5f52-4ae4-b1da-6d181b640c9b.htm -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Tomá¹ Vojtìch" <tomas.vojtech@deltax.cz> wrote in message news:O2CWCZ1CIHA.4196@TK2MSFTNGP04.phx.gbl... > Hello, > sql server 2005 uses by default pesimistic locking during select execution. Is there any > possibility in server setup to tell him to use optimistic locking? > > Thank you for your advice > Tomas Vojtech > |
|
![]() |
| Outils de la discussion | |
|
|