I got problem when MS SQL Service got sudden shutdown or restart the identity is jump by 1000.
To solve this problem use “-T272”
1. Open “SQL Server Configuration Manager”
2. Click “SQL Server Services” on the left pane
3. Right-click on your SQL Server instance name on the right pane
4. Click “Properties”
5. Click “Startup Parameters”
6. On the “specify a startup parameter” textbox type “-T272”
7. Click “Add”
8. Confirm the changes
I hope this can solve the problem.