The blocked column in the sysprocesses table is populated for latch waits after you install SQL Server 2000 SP4

After you install Microsoft SQL Server 2000 Service Pack 4 (SP4), you may notice that the blocked column in the sysprocesses system table is populated for latch waits in addition to lock waits. Sometimes, you may notice brief periods of time when a single server process ID (SPID) is reported as bloc

Read More - Register for Free Membership