MSDTC

SQLServerCentral Article

Windows Clustered MSDTC and SQL Server 2019 mishap

  • Article

Introduction As you may know, in the early days of SQL Server Clustering, Microsoft advised to provide each clustered SQL Server instance with its own Microsoft Distributed Transaction Coordinator (MSDTC) resource. Since SQL Server 2012 this advice has been withdrawn. Microsoft now recommends to provide your instance with its own MSDTC resource, once you notice the […]

(4)

You rated this post out of 5. Change rating

2025-04-04

3,350 reads

Blogs

From SQL Saturday to Day of Data

By

A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...

PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters

By

You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...

A New Word: La Guadière

By

la guadière – n. a glint of goodness you notice in something that you...

Read the latest Blogs

Forums

non ascii columns in a utf-8 .txt file

By stan

hi, we couldnt get our upstream data source developers to supply what is sometimes...

PolyBase Trace Flags

By Leo.Miller

Are there any good articles on all the trace flags that are enabled on...

The Data Model Matters

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Data Model Matters

Visit the forum

Question of the Day

Running SQLCMD I

I run the SQLCMD utility as follows:

lcmd -S localhost -E
I then type this (the 1> is the prompt):
1> select @@version go
If I hit enter, what happens?

See possible answers