my problem is SQL related, when my machine restart, after that when i insert new record in SQl then my identity colomn skip 1000 rows and identity start 20001 , if my machine again restart then identity colomn skip 20001 and start 30001 , how to solve this problem.
my machine restart and sql server table identity colomn skip 1000 rows and identity start 20001.
New contributor
Muhammad Ammar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.