Ticket ID increased automatically

[maxluc]

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

[Obi_1_Cinobi]

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:

• https://blog.sqlauthority.com/2017/03/24/sql-server-jump-identity-column-restart/
• https://stackoverflow.com/questions/14146148/identity-increment-is-jumping-in-sql-server-database

[Obi_1_Cinobi]

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.

• https://www.lansweeper.com/knowledgebase/resetting-the-ticket-id-counter/
• https://www.lansweeper.com/knowledgebase/deleting-help-desk-tickets/