Long story short I've got my local development machine into a bit of a mess with MSDTC and I have the horrible red arrow in DCOM. I have an application that uses MSDTC and MSMQ, and it's got itself stuck. Just to be clear, the SQL Server instance is Express and it is running on my machine. Everything is local to my machine is this case for my development purposes.
I have uninstalled MSDTC, MSMQ and then reinstalled MSDTC and reset the log and then installed MSMQ again, however the issue remains. Clicking on COM+ gives the following error:
Delving into MSDTC I can see no active transactions, but curiously the summary totals show 5 transactions, even though none are in the list:
Moving over to SQL Server, the following commands all return no rows:
- SELECT @@trancount
- DBCC OPENTRAN
- SELECT XACT_STATE()
However, the last query against
sys.dm_tran_active_transactions returns 5 rows:
It looks like my machine was in the middle of a debugging session, I left it running and then early in the morning, my machine rebooted.
I would like to remove these orphaned transactions, but I'm not sure how. Can I just DELETE FROM sys.dm_tran_active_transactions without any negative impact so I can go back to using MSDTC without issues.