Many people are asking the question called: Why does Identity Value Jump after restarting SQL Server? In this article, we will provide the solution to get rid of this unwanted jumping. It is one of the common FAQs. Let me create a table and insert a new record.

If any reason restarts your SQL Server Instance, then the identity column will insert 1000, 10000, etc

Solution: Identity Value Jumps after restarting SQL Server
Go to the SQL Server Configuration Manager. Next, right-click on the Instance Name, and select the properties from the context menu.

Selecting the properties window will open the following window

Go to the Startup Parameters Tab and add -T272

Click Apply

Click OK and restart the SQL Server instance
