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