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?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (