Enable the Windows Distributed Transaction Coordinator

Windows ServerOne 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 which use transaction boundaries.

Blog Syndicated with azurecurve’s Permission

Author: Ian Grieve

Share This Post On
Share via
Copy link
Powered by Social Snap