ive had this a few times and never got a sucessfull explanation for it ...

it normally happens to me if i'm running an xp in 2000 (such as xp_cmdshell) if the xp crashes sql2000 doesn't seem to want to do anything with it.

i've always had to reboot (despite searching for an eternity for the fix)

perhaps since then someone has found a fix