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
Posted Wednesday, December 25, 2013 6:55 AM


Group: General Forum Members
Last Login: Thursday, January 28, 2016 2:04 AM
Points: 100, Visits: 395
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


Group: General Forum Members
Last Login: Tuesday, February 2, 2016 7:40 AM
Points: 2,975, Visits: 3,542
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. 1 February 2016: now over 36,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