DTC Enabled

• gupta1282

  Default port

  Points: 1465

  More actions

  December 16, 2009 at 7:28 am

  #156511

  Hi All

  I have one doubt

  I know this can be foolish querstion to ask but I want to clear my confusion

  when DTC(Distributed transaction cordinator) should be enabled ?

  I read article to execute distributed queries , we need to start/enabled

  What is mean of distributed queries

  we can use linked servers to execute queries on remote servers

  Is there any difference between Linked server Concept & DTC enabled

  Thanks

  Ghanshyam

• Bru Medishetty

  SSC-Insane

  Points: 23606

  More actions

  December 16, 2009 at 7:42 am

  #1093000

  Please don't cross post.

  ---

  Bru Medishetty

  Blog -- LearnSQLWithBru

  Join on Facebook Page Facebook.comLearnSQLWithBru

  Twitter -- BruMedishetty

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736212

  More actions

  December 16, 2009 at 9:00 am

  #1093089

  Sorry, Bru, I removed the other post. I'll edit yours.

  The DTC service ensures that a transaction that crosses two servers, say an insert, actually completes on both servers. There are some things that you try to do in Linked Servers that require the DTC service.

  you can read a bit about it here: http://www1bpt.bridgeport.edu/~jelee/courses/CS450_F09/CPSC450-ExerciseLab1-Supporting-EER.pdf