Unfortunately we have not been able to find a suitable solution. We ended up writing a SQLAgent job that runs every 10 mins and kills any processes that are hung...

Thanks again Markus, It should be easy enough to script. We can run it just b4 the DBCC jobs are executed. That should do it.

Markus,

Thanks for the info. That is very very helpful.

I do have one followup question though. Is there a way to detect and automatically 'timeout' the orphaned DTC transactions ?...