Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

what is orphaned DTC transaction in sql server Expand / Collapse
Author
Message
Posted Wednesday, December 25, 2013 6:55 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, May 30, 2016 1:54 AM
Points: 100, Visits: 405
Hi Can some one tell me in simple what is orphaned DTC transaction in sql server.
Post #1525889
Posted Friday, January 3, 2014 3:11 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, August 23, 2016 5:06 AM
Points: 3,034, Visits: 3,709
There are a number of issues that can cause this situation.

A Google search on 'Orphan MSDTC Transaction' will give you a number of references about potential causes and how to troubleshoot them.


Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2016, 2014, 2012, 2008 R2, 2008 and 2005. 11 May 2016: now over 37,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Quote: "When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist." - Archbishop Hélder Câmara
Post #1527416
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse