Today's problem is: Reading notes of SQL SERVER2012 database after the restart of the ID value Jump 1000 problem, this problem has been tested and not completely solved, very sorry!
Blog Combat:
(读后感http://www.simayi.net读书笔记)
, focus on reading notes and write the blog, learning to share.
Problem Description:
Established a data table, the ID is set to the self-increment field, the identity specification and seed are set to 1, so that the added record has been increased, equivalent to the automatic numbering in the Access database, it is very convenient, but when you restart the server or restart the SQL Server server, this value is not self-increment 1 , but since the increase of 1001, jumping 1000 of the value, very annoying!
After accessing the information and consulting some great gods found that there is a way to try:
Solution:
1. Open Computer Management (run, input compmgmt.msc, enter).
2. Services and Applications –>sql Server Configuration Manager –>sql Server service –> Select the SQL Server instance, right-click, select the Properties menu. Locate the startup parameters in the pop-up window, and then add-t272 to restart the instance in the SQL Server service.
Conclusion Test:
Found that this did not completely solve the problem, anyway, after my database restart and server restart, the ID value is still jumping, increased the value of 1000, which is very annoying, irritating.
I wonder if there is any great God who can solve this problem completely. Some please inform, greatly appreciate!
Reading notes SQL server2012 database restart self-increment ID value Jump 1000 workaround