Enable the Windows Distributed Transaction Coordinator

One of the line of business applications used by a few clients performs updates to both it’s own database and also the Microsoft Dynamics GP database. It does this using code in SQL stored procedures which use transaction boundaries.

As the updates are between SQL servers, it does this using BEGIN DISTRIBUTED TRANSACTION rather than the usual BEGIN TRANSACTION; updates of this sort are, as…

Continue Reading azurecurve’s Article on their blog

Enable the Windows Distributed Transaction Coordinator

One of the line of business applications used by a few clients performs updates to both it’s own database and also the Microsoft Dynamics GP database. It does this using code in SQL stored procedures‎…

Blog Syndicated with azurecurve’s Permission