‎11-08-2022 12:43 PM
Hi everybody,
we started our helpdesk system after a test period manually resetting the ticket ID number to #1.
At ticket #57, the system has increased by 1000 the id, that now is #1058 .
What can i do to bring back the id to #58?
Thanks in advance for your help.
Massimo
‎11-09-2022 09:36 AM
Hello there!
The behavior you are reporting is a known issue or feature with Microsoft SQL Server 2012 and higher. This feature by Microsoft causes the identity column to increase by 1000 with each SQL Server restart. There are potentially some workarounds that you can apply on SQL Server level to prevent this from occurring, but we have not tested these ourselves. More information about this behavior can be found here:
‎11-09-2022 09:38 AM
Additionally, you can reset the ticket ID counter following the instructions below, but you will need to delete all tickets with a 10nn ticket number first.
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now