Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, October 16, 2014 11:51 PM
Points: 72, Visits: 263
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
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, October 22, 2014 4:18 AM
Points: 2,886, Visits: 3,256
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 2014, 2012, 2008 R2, 2008 and 2005. 18 October 2014: now over 31,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #1527416
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse