→ Upcoming Product Keynote - Introducing Lansweeper's 2023 Fall Release Register here

Showing results for 
Show  only  | Search instead for 
Did you mean: 
Engaged Sweeper

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.


Lansweeper Tech Support
Lansweeper Tech Support

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:


Lansweeper Tech Support
Lansweeper Tech Support

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.