Jump to content

SQL server 2012 ID skipping problem

im facing this weird situation where my ID columns which has been set to auto increment skips numbers, jumps numbers by 2 or 3 and sometimes it jumps a number then later goes back to the number which was missed and continues from there. once my ID even jumped by 1000. i googled this problem and i found this solution where  i have to go to SQL server service, go to start up parameters and insert -t272. i have also posted a screenshot on this. i hope i did that right. after that it didnt jump a 1000 but it still keeps doing this jumping by 2 and 3 and sometimes going back. i have posted a screenshot on this as well. it happen in random tables and at random times so i have not find it possible to detect a pattern and tell when it will happen again

sq.JPG

sql.JPG

Link to comment
Share on other sites

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×