In my work with the employee punching I needed to be able to answer a request on changed employees. In NAV 2009 R2 we got the CRM Connector and that included database triggers that are executed when the data is modified. Previously we only had global triggers that where executed when the table triggers where executed. That meant that a C/AL INSERT, MODIFY, DELETE or RENAME did not fire a global trigger but they do fire the database triggers.
Posted inDynamics NAV & BC Tips & tricks