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: Sunday, April 13, 2014 1:50 PM
Points: 62, Visits: 214
Hi Can some one tell me in simple what is orphaned DTC transaction in sql server.
Post #1525889
Posted Friday, January 03, 2014 3:11 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 7:37 AM
Points: 2,798, Visits: 3,081
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. 25 March 2014: now over 28,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