locking problem in MTS with vb

[zeevgetner]

i have a problem, using vb with mts.
when i start a transaction, the mts locks every table,
which i selected from' for update, and locks every table i updated, for select and update. until the end of the transaction

what i want is for the locks to be on the update only, and for the the updated record only.

is there a way i can do it ?

 

[TomSark]

MTS Default SQL Server
Transaction SQL Server Enlisted In Transaction
Setting Isolation Level DTC Type
---------------------------------------------------------------------------------------------
Requires New Serializable Yes Explicit
Requires Serializable Yes Explicit
Supports (1) Serializable Yes Explicit
Supports (2) Read Committed No Autocommit
Does Not Support Read Committed No Autocommit

(1) If the object is involved in a transaction
(2) If the object is not involved in a transaction

Why did I put this together?
For components involved in transactions, MTS by default uses the serializable isolation level on SQL Server, which could cause a concurrency problems such as blocked processes and deadlocks. If not absolutely necessary to use the serializable isolation level, developers should set the SQL Server isolation level to read committed so that they can obtain higher concurrency (fewer blocked transactions, fewer deadlocks).
Tom Davis
tdavis@sark.com

http://www.sarkdallas.com