Hi,

We are running into a situation that multiple processes are blocking each other (not dead lock). When I use sp_who to show the processes, it show the blocking process' status is 'sleeping'!!! So does it mean it's not doing anything now? If that's the case, why it's still blocking other processes?

Also, when using sp_lock, if the status column shows 'Grant', does it mean the lock is being granted to the current process? How do I find more detailed explaination on the fields of sp_who and sp_help. BOL doesn't seem to be enough.

Thanks a lot!

Elaine






MS Sql Server LazyDBA home page