I'm having the problem described here
When checking current activity (E.Manager - sql2000) I get a time out.
No matter how many times I refresh I get the same.
I have run sp_lock but don't really understand the results.
There are a couple of SPids that appear many many many times! (user accounts). I'm not familiar with the application they are using so am not sure it is normal activity.
Mosty of the objectids are 1,2,3,...12 etc but one of them is 442102604 (how can I tell what this is? should I care? I only mention it as the number is astronomically higher than the others)
Under resource I have entries such as (4e00e7c9a11a) (what does this hex represent?)
Under mode what is Sch-M?