At a customer site, we sometimes saw that the recid is “jumping” in Dynamics AX 2009. We cannot explain why, but it seems to happen a few times every year. To deal with this, we created the following SQL trigger :
Thanks to FSB-development that came up with this. I share it to the community, because it would be easy to modify for other purposes.