table locking

[luis_augusto]

Opening a query with a select without a "where" clause causes the locking of the entire table, jeopardizing multiple-user access:

Ex.

Select * from table
order by
field1,field2


I´ve tried

Select * from table with (nolocks)
order by
field1,field2

But it did change nothing

What could possibly be?

Thanks

[Jackson]

It is possible that you use FetchAll = False mode.
Query execution in such mode blocks current session.
In order to avoid session blocking OLE DB creates an additional session which causes table blocking.