Home Forums SQL Server 2008 SQL Server 2008 High Availability SQL DTC Confusion RE: SQL DTC Confusion

  • February 26, 2013 at 11:14 pm

    #1591391

    opc.three (2/26/2013)

    SQL also will the DTC if you try using explicit transactions with Linked Servers. I also use it with SSIS transactions, not technically the database engine but another use of DTC nonetheless.

    Thanks

    So even if SQL is installed as non clustered, DTC can still become involved somehow

    If that's the case, why when dealing with Clustered instances of SQL Server do we have to explicitly create a DTC component in the Cluster?

    Thanks