Query timeout

Hi Group,

I using VB 6 and doing a query on an SQL server database.
The query is on a view and has worked fine for a year or so.
All of a sudden the user is getting query timeout.
This is not due to data size as the query can come back fairly
quickly.

In the code for my db connection I have done the follow
so I don't get held up by locked records.

db.IsolationLevel = adXactReadUncommitted
db.BeginTrans
db.CommitTrans
db.CommandTimeout = 60

However yesterday while my application was held up.
I could still do a query on the same view in SQL server or query
analyser without a problem.

Strangely I did a query

select * from table withlock;
then
select * from table with nolock;

and the problem strangely went away.

I'm convinced that it must be locking of some kind
but using SQL Manager I couldn't see any locks on the tables in
question.

Any ideas what is wrong, what I am doing wrong or how do find what is
holding
up the query?