One of our applications has reported the error in the ADO.NET stack “The transaction is in doubt” when the SQL Server was under heavy load. I've read around this area and I'm confused!
Some sources seem to say this is purely an MSDTC error within a system transaction, and that the database transaction will have either completed or rolled back. It's just that MSDTC doesn't know which it was (in other words, my database is still internally consistent).
However I also read this article: http://technet.microsoft.com/en-us/library/ms179586.aspx
This seems to say that in doubt transactions will remain in my database and should I restart SQL Server it will fail to recover (by default) although it explains how I can change that.
I've never had this error before. Can anyone offer any more details on what it means and whether I need to take any corrective actions please?
Thanks in ancipation
Tim Walker