I need you help. I am developing application with SQL server 6.5 SP5a
and VB5.0 ADO 2.0. I notice when a clients has begin a transaction,
the whole SQL Server will be locked from other client's request, even
SELECT.

Do you have the same experience as mine? Any solution for me.

Regards,

Poon Chak Yau.

Perhaps you are hitting the blocking problem in tempdb.

What may be happening is that temporary stored procedures are being created
in tempdb inside the transaction (due to prepare statement option), this
will serialise access to tempdb.

You need to disable to 'generate stored procedure for prepare statement'
option.

--
Hope the above helps.

Tony Rogerson MCP, MS SQL Server MVP
Torver Computer Consultants Ltd
London, England.