BizTalk Server General - process -2 is blocking the sql 2000

Author

process -2 is blocking the sql 2000

haggai.shachar@gmail.com

2006-01-30, 2:48 am

Hi,
I have this wierd thing in SQL 2000 running BizTalk-
some of the processes are locked by process -2 (minus 2), but I can't
find that process, and I can't kill it from the query analyzer.

The result is that some of my SQL agent jobs are stuck, but BizTalk
itself seems to be running ok (well, I didn't wait too long, maybe it's
processes whould have got stuck later on)

The only solution is to stop/start the service - but then it happends
every once a day/two.

Any idea ??

Thanks,
Haggai