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