Home Forums SQL Server 7,2000 Administration Blocking RE: Blocking
Ian Scarlett
SSC-Insane
Points: 23197
More actions
September 17, 2008 at 3:17 am
#872883
A SPID blocking itself is actually SQL Server's way of showing that a SPID is waiting for I/O to complete... these never used to be shown in sysprocesses/sp_who2 until SP3 or SP4 (can't remember which one introduced the change).