> How do I start debugging this one?

Self blocking spid's may be due to latch waits
(http://support.microsoft.com/kb/906344) or intra-query parallelism. In the
later case, you will have multiple rows for the same spid with the blocked
ones showing CXPACKET wait types.

--
Hope this s.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

"cw" <cw@3mc.com> wrote in message
news:eggVBv4kIHA.5160@TK2MSFTNGP05.phx.gbl...
> What do I need to look at to find out why a query shows it is blocking
> itself?
> This is a SQL2000 sp4 server on Win2003 with a query on a table containing
> ~20million rows. Someone wrote a query w/i an application that ends up
> doing a table scan, and when this occurs sp_who2 is showing the spid
> blocking itself.
>
> How do I start debugging this one?
> Thanks
>