Most RecentMost ViewedMost LikesThe Case of the Phantom Spid: Troubleshooting and Resolving an Orphaned DTC Transaction First published on MSDN on Jun 23, 2009 Several weeks ago one of our customers encountered an issue in which an index maintenance job that had always completed successfully, began failing with each nightly run.