Database lock makes all Clients hold

We are using SQL2000 with SP3, Windows 2000 Svr Std with SP4
Sometimes, we found all clients had no response. Later, we found that the
all clients are waiting response from sql server.
Then in querry analyzer, we use this script:
select * FROM master..sysprocesses where status='sleeping' AND
waittype=0x000 AND open_tran > 0
and then we found out one computer is locking and after request that
computer logout the program, then, all clients can run again.
However, I have no idea why this case happen and I am still searching what's
the meaning the about select statement.
Can anyone help me?
IvanTalk to the person who wrote that program, as you have a bug in the application because it doesn't
and the transaction properly.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Ivan Kan" <ivankan@.no-ip.com> wrote in message news:uJg1Qb3lDHA.1740@.TK2MSFTNGP12.phx.gbl...
> We are using SQL2000 with SP3, Windows 2000 Svr Std with SP4
> Sometimes, we found all clients had no response. Later, we found that the
> all clients are waiting response from sql server.
> Then in querry analyzer, we use this script:
> select * FROM master..sysprocesses where status='sleeping' AND
> waittype=0x000 AND open_tran > 0
> and then we found out one computer is locking and after request that
> computer logout the program, then, all clients can run again.
> However, I have no idea why this case happen and I am still searching what's
> the meaning the about select statement.
> Can anyone help me?
> Ivan
>
>