David Musgrave covers Differences with SQL Transaction Rollback behaviour for eConnect for Microsoft Dynamics GP 2010
Differences with SQL Transaction Rollback behaviour for eConnect for Microsoft Dynamics GP 2010 – Developing for Dynamics GP – Site Home – MSDN Blogs
SQL & DataDevelopment & IntegrationMicrosoft & the GP EcosystemGP 2010
Archived post from 2012. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.