Error Message 17883 (Scheduler 5 appears to be hung)

we have this problem
1. whereby sql transaction is blocked by spid -2
2. check the error log it dump mini dump at 4.00am
3. error log repeat with
The Scheduler 5 appears to be hung. SPID 102, ECID 0, UMS Context 0x03ADD340.
Error: 17883, Severity: 1, State: 0
3. blocking happen at 10.00am
4. kill the spid id with -2, can't
5. restart sql server and sqlserver resume.
Any idea what happen?Its known bug...
http://support.microsoft.com/kb/835581
RESOLUTION:
Service pack information
To resolve this problem, obtain the latest service pack for SQL Server 2000.
Thanks,
Sree
"soonyu" wrote:
> we have this problem
> 1. whereby sql transaction is blocked by spid -2
> 2. check the error log it dump mini dump at 4.00am
> 3. error log repeat with
> The Scheduler 5 appears to be hung. SPID 102, ECID 0, UMS Context 0x03ADD340.
> Error: 17883, Severity: 1, State: 0
> 3. blocking happen at 10.00am
> 4. kill the spid id with -2, can't
> 5. restart sql server and sqlserver resume.
> Any idea what happen?
>