Thanks Michael. I was hoping to avoid the restart, but it looks like there are no alternatives. I've never restarted a server before. Any things to watch out for other than to avoid doing it when the DBs are in high demand?
If the transaction is actually rolling back and not hung up, then you won't gain anything from restarting the server. When it comes back up, it will just continue rolling back the transaction.
I've had processes take as long to roll back as it had been running before being killed.
Can you tell us more about what the process is, how long it's been running, and why it is rolling back?