Blocking

Hi everybody
I have a process in a SQL Server 2000 database that is blocking itself, is
that normal? The sp_who output looks like this:
Process id: 80
Hostname: XXXXX
user: XXX
..
..
Blkby: 80
I would appreciate any advice.
HaroldIt depends. It can happen and it may or may not be
problematic. Check the following article - this may be what
you are seeing:
The blocked column in the sysprocesses table is populated
for latch waits after you install SQL Server 2000 SP4
http://support.microsoft.com/?id=906344
-Sue
On Mon, 9 Oct 2006 10:19:01 -0700, haRold
<haRold@.discussions.microsoft.com> wrote:
>Hi everybody
>I have a process in a SQL Server 2000 database that is blocking itself, is
>that normal? The sp_who output looks like this:
>Process id: 80
>Hostname: XXXXX
>user: XXX
>..
>..
>Blkby: 80
>I would appreciate any advice.
>Harold