{"id":193,"date":"2008-11-13T11:00:08","date_gmt":"2008-11-13T11:00:08","guid":{"rendered":"http:\/\/itknowledgeexchange.techtarget.com\/sql-server\/what-exactly-is-msdtc-any-when-do-i-need-it\/"},"modified":"2021-04-05T12:51:28","modified_gmt":"2021-04-05T19:51:28","slug":"what-exactly-is-msdtc-any-when-do-i-need-it","status":"publish","type":"post","link":"https:\/\/www.dcac.com\/2008\/11\/13\/what-exactly-is-msdtc-any-when-do-i-need-it\/","title":{"rendered":"What exactly is MSDTC, and when do I need it?"},"content":{"rendered":"

<\/a><\/p>\n

MSDTC (aka Microsoft Distributed Transaction Control) is a piece of software that a lot of people use, but they don’t really know what it does, or how it works.<\/p>\n

MSDTC is used by SQL Server and other applications when they want to make a distributed transaction between more than one machine.\u00a0 A distributed transaction is simple a transaction that spans between two or more machines.\u00a0 The basic concept is that machine 1 starts a transaction, and does some work.\u00a0 It then connects to machine 2 and does some work.\u00a0 The work on machine 2 fails and is canceled.\u00a0 The work on machine 1 needs to then be rolled back.<\/p>\n

DTC is for the most part a black box.\u00a0 It just sort of works without much interaction except for the initial setup.<\/p>\n

The only time that DTC needs to be used is when more than one physical computer is going to be involved in an explicit distributed transaction.\u00a0 If you are going from one instance to another on the same server DTC will not be needed.\u00a0 If you are going from one instance to another within a cluster you will want to have DTC available as you may have to go between nodes of the cluster as you have no guarantee that the instances will be on the same physical node.<\/p>\n

I hope this helps explain DTC a little bit at least.\u00a0 If you have specific questions about DTC, feel free to post them below and I’ll try and find the answers for you.<\/p>\n

Denny<\/p>\n","protected":false},"excerpt":{"rendered":"

MSDTC (aka Microsoft Distributed Transaction Control) is a piece of software that a lot of people use, but they don’t really know what it does, or how it works. MSDTC is used by SQL Server and other applications when they want to make a distributed transaction between more than one machine.\u00a0 A distributed transaction is […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[551,1],"tags":[],"class_list":["post-193","post","type-post","status-publish","format-standard","hentry","category-blog","category-uncategorized"],"yoast_head":"\nWhat exactly is MSDTC, and when do I need it? – Denny Cherry & Associates Consulting<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dcac.com\/2008\/11\/13\/what-exactly-is-msdtc-any-when-do-i-need-it\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What exactly is MSDTC, and when do I need it? – Denny Cherry & Associates Consulting\" \/>\n<meta property=\"og:description\" content=\"MSDTC (aka Microsoft Distributed Transaction Control) is a piece of software that a lot of people use, but they don’t really know what it does, or how it works. MSDTC is used by SQL Server and other applications when they want to make a distributed transaction between more than one machine.\u00a0 A distributed transaction is […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dcac.com\/2008\/11\/13\/what-exactly-is-msdtc-any-when-do-i-need-it\/\" \/>\n<meta property=\"og:site_name\" content=\"Denny Cherry & Associates Consulting\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DennyCherryAssociatesConsulting\/\" \/>\n<meta property=\"article:published_time\" content=\"2008-11-13T11:00:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-04-05T19:51:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dcac.com\/ad\/primary_image\/itke_msdtc\" \/>\n<meta name=\"author\" content=\"Denny Cherry\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@mrdenny\" \/>\n<meta name=\"twitter:site\" content=\"@dcacco\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Denny Cherry\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dcac.com\/2008\/11\/13\/what-exactly-is-msdtc-any-when-do-i-need-it\/\",\"url\":\"https:\/\/www.dcac.com\/2008\/11\/13\/what-exactly-is-msdtc-any-when-do-i-need-it\/\",\"name\":\"What exactly is MSDTC, and when do I need it? – Denny Cherry & Associates Consulting\",\"isPartOf\":{\"@id\":\"https:\/\/www.dcac.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dcac.com\/2008\/11\/13\/what-exactly-is-msdtc-any-when-do-i-need-it\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dcac.com\/2008\/11\/13\/what-exactly-is-msdtc-any-when-do-i-need-it\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dcac.com\/ad\/primary_image\/itke_msdtc\",\"datePublished\":\"2008-11-13T11:00:08+00:00\",\"dateModified\":\"2021-04-05T19:51:28+00:00\",\"author\":{\"@id\":\"https:\/\/www.dcac.com\/#\/schema\/person\/cbc8485c710a3eee0e50dcfa9518636e\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dcac.com\/2008\/11\/13\/what-exactly-is-msdtc-any-when-do-i-need-it\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dcac.com\/2008\/11\/13\/what-exactly-is-msdtc-any-when-do-i-need-it\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dcac.com\/2008\/11\/13\/what-exactly-is-msdtc-any-when-do-i-need-it\/#primaryimage\",\"url\":\"https:\/\/www.dcac.com\/ad\/primary_image\/itke_msdtc\",\"contentUrl\":\"https:\/\/www.dcac.com\/ad\/primary_image\/itke_msdtc\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dcac.com\/2008\/11\/13\/what-exactly-is-msdtc-any-when-do-i-need-it\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.dcac.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What exactly is MSDTC, and when do I need it?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dcac.com\/#website\",\"url\":\"https:\/\/www.dcac.com\/\",\"name\":\"Denny Cherry & Associates Consulting\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dcac.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dcac.com\/#\/schema\/person\/cbc8485c710a3eee0e50dcfa9518636e\",\"name\":\"Denny Cherry\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dcac.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ccade9c22d8686e4b5a46cb49a636eea?s=96&r=x\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ccade9c22d8686e4b5a46cb49a636eea?s=96&r=x\",\"caption\":\"Denny Cherry\"},\"sameAs\":[\"https:\/\/x.com\/mrdenny\"],\"url\":\"https:\/\/www.dcac.com\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What exactly is MSDTC, and when do I need it? – Denny Cherry & Associates Consulting","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dcac.com\/2008\/11\/13\/what-exactly-is-msdtc-any-when-do-i-need-it\/","og_locale":"en_US","og_type":"article","og_title":"What exactly is MSDTC, and when do I need it? – Denny Cherry & Associates Consulting","og_description":"MSDTC (aka Microsoft Distributed Transaction Control) is a piece of software that a lot of people use, but they don’t really know what it does, or how it works. MSDTC is used by SQL Server and other applications when they want to make a distributed transaction between more than one machine.\u00a0 A distributed transaction is […]","og_url":"https:\/\/www.dcac.com\/2008\/11\/13\/what-exactly-is-msdtc-any-when-do-i-need-it\/","og_site_name":"Denny Cherry & Associates Consulting","article_publisher":"https:\/\/www.facebook.com\/DennyCherryAssociatesConsulting\/","article_published_time":"2008-11-13T11:00:08+00:00","article_modified_time":"2021-04-05T19:51:28+00:00","og_image":[{"url":"https:\/\/www.dcac.com\/ad\/primary_image\/itke_msdtc","type":"","width":"","height":""}],"author":"Denny Cherry","twitter_card":"summary_large_image","twitter_creator":"@mrdenny","twitter_site":"@dcacco","twitter_misc":{"Written by":"Denny Cherry","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.dcac.com\/2008\/11\/13\/what-exactly-is-msdtc-any-when-do-i-need-it\/","url":"https:\/\/www.dcac.com\/2008\/11\/13\/what-exactly-is-msdtc-any-when-do-i-need-it\/","name":"What exactly is MSDTC, and when do I need it? – Denny Cherry & Associates Consulting","isPartOf":{"@id":"https:\/\/www.dcac.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dcac.com\/2008\/11\/13\/what-exactly-is-msdtc-any-when-do-i-need-it\/#primaryimage"},"image":{"@id":"https:\/\/www.dcac.com\/2008\/11\/13\/what-exactly-is-msdtc-any-when-do-i-need-it\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dcac.com\/ad\/primary_image\/itke_msdtc","datePublished":"2008-11-13T11:00:08+00:00","dateModified":"2021-04-05T19:51:28+00:00","author":{"@id":"https:\/\/www.dcac.com\/#\/schema\/person\/cbc8485c710a3eee0e50dcfa9518636e"},"breadcrumb":{"@id":"https:\/\/www.dcac.com\/2008\/11\/13\/what-exactly-is-msdtc-any-when-do-i-need-it\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dcac.com\/2008\/11\/13\/what-exactly-is-msdtc-any-when-do-i-need-it\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dcac.com\/2008\/11\/13\/what-exactly-is-msdtc-any-when-do-i-need-it\/#primaryimage","url":"https:\/\/www.dcac.com\/ad\/primary_image\/itke_msdtc","contentUrl":"https:\/\/www.dcac.com\/ad\/primary_image\/itke_msdtc"},{"@type":"BreadcrumbList","@id":"https:\/\/www.dcac.com\/2008\/11\/13\/what-exactly-is-msdtc-any-when-do-i-need-it\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dcac.com\/"},{"@type":"ListItem","position":2,"name":"What exactly is MSDTC, and when do I need it?"}]},{"@type":"WebSite","@id":"https:\/\/www.dcac.com\/#website","url":"https:\/\/www.dcac.com\/","name":"Denny Cherry & Associates Consulting","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dcac.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dcac.com\/#\/schema\/person\/cbc8485c710a3eee0e50dcfa9518636e","name":"Denny Cherry","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dcac.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ccade9c22d8686e4b5a46cb49a636eea?s=96&r=x","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ccade9c22d8686e4b5a46cb49a636eea?s=96&r=x","caption":"Denny Cherry"},"sameAs":["https:\/\/x.com\/mrdenny"],"url":"https:\/\/www.dcac.com\/author\/admin\/"}]}},"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/posts\/193","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/comments?post=193"}],"version-history":[{"count":2,"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/posts\/193\/revisions"}],"predecessor-version":[{"id":42206,"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/posts\/193\/revisions\/42206"}],"wp:attachment":[{"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/media?parent=193"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/categories?post=193"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/tags?post=193"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}