Announcements
In MS Dynamics GP2016. SQL table CM20200 Dex_Row_ID is skipping around 900 numbers in period of one month or two month gaps.
Can you help me to find out the reason for skipping the Dex_Row_ID.
*This post is locked for comments
If everything else is in sequence then either SQL was stopped and restarted or the server was rebooted. An identity column cannot be modified.
No, other number is in sequence like audit trail code.
I forgot to mention that you should check with your IT staff and see if these gaps correspond to when your GP SQL server was rebooted. Stopping and starting the SQL Server will also cause gaps in identity columns.
The most obvious explanation would be that someone is deleting records from that table. Do you a corresponding gap in the dates of those transactions?
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
