Lot of 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. This is one of the common SQL FAQ.
Let me create a Table, and insert a New record
If your SQL Instance is restarted by any reason 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 OK and restart the SQL Server instance