Patrick Roth at Developing for Dynamics GP looks at a development scenario where SQL DB Insert Trigger Breaks Dexterity Active Locking.
SQL DB Insert Trigger Breaks Dexterity Active Locking
SQL & DataDevelopment & Integration
Archived post from 2010. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.