> It is the other way around, the with(nolock) hint means that the
> SELECT doesn't get locked by anyone.
>
> This is what I want.

Perhaps you are using by accident, either

* the NO RECORD_VERSION option when starting a transaction, or
* the WITH LOCK clause in a concurrent SELECT statement

Both things happily decrease multi-user concurrency performance.



--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com