FIX: sp_lock Does Not Indicate Blocking Lock
  
PSS ID Number: Q110986
Article last modified on 10-31-1994
 
4.20
 
Windows
 

----------------------------------------------------------------------
The information in this article applies to:
 
  - Microsoft SQL Server version 4.2
----------------------------------------------------------------------
 
BUG# NT: 640 (4.2)
 
SYMPTOMS
========
 
Sp_lock does not correctly indicate a blocking lock. For example if a
shared page lock is blocked on an exclusive table lock, sp_lock should, but
does not, indicate this entry under the locktype column:
 
   Ex_table-blk
 
WORKAROUND
==========
 
You can use the BLK column of sp_who to see what connection you are
blocked on.
 
STATUS
======
 
Microsoft has confirmed this to be a problem in Microsoft SQL Server
version 4.2. This problem was corrected in SQL Server version 4.21. For
more information, contact your primary support provider.
 
Additional reference words: 4.20 Windows NT
KBCategory: kbprg
KBSubcategory: SSrvWinNT
 
=============================================================================
 
Copyright Microsoft Corporation 1994.
