Microsoft KB Archive/110986

FIX: sp_lock Does Not Indicate Blocking Lock

PSS ID Number: Q110986 Article last modified on 10-31-1994

4.20

Windows

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.