It may or may not go through the same recovery process - sometimes it comes right back online and others it starts the recovery and rollback process again. But it doesn't seem like there would be much to roll back. Before restarting, take a look at what's in the Distributed Transaction Coordinator. I've found things stuck in there before and a restart of the DTC coordinator was all that was needed. Start Run dcomcnfg - > Computers - My Computer - Distributed Transaction Coordinator.
Sue
Sue, The transaction list is empty, but the Transactions Statistics show Current: Max Active as 1.
I restarted the DTC service on the Windows machine, but the session is still open and shows it is still running the same INSERT statement in SQL Server.
Dang...was hoping that would work. Sometimes does, sometimes doesn't. And yeah the Transaction Statistics is what you would want to look at - sorry I left that out. It may just be time to bite the bullet now and restart the SQL service. Here is hoping it's one that goes fast...post back if you restart. I'd like to know if it was quick or not. I still keep thinking it would be quick since you found the number of rows affected and it wouldn't be much.
Sue