sql server 2000: release lock on table?

Question

I run the following query

select * from my t1 where c1 = 22

and query runs for ever.. How can I find out whats locking that row?

I tried runnning sp_who, sp_who2, sp_lock, and googled for information but still no resolution in sight.

Please help.

I am using sql server 2000.

Answer 1

You look at blocked, waittype, waittime and waitresource on sysprocesses.