Identity Value Jumps after restarting SQL Server

Many people are asking the question called: Why Identity Value Jumps 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 SQL FAQ. Let me create a table, and insert a new record

Identity Value Jumps after restarting SQL Server 1

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

Identity Value Jumps after restarting SQL Server 2

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.

Identity Value Jumps after restarting SQL Server 3

Selecting the properties window will open the following window

Identity Value Jumps after restarting SQL Server 4

Go to the Startup Parameters Tab and add -T272

Identity Value Jumps after restarting SQL Server 5

Click Apply

Identity Value Jumps after restarting SQL Server 6

Click OK and restart the SQL Server instance