Auto ID generated jumping Values 1000 .. please Urgent

Feb 2 2018 1:18 AM

Hi. I am Create Auti Ganerated ID with primary key.

so, the problem is, first 535 number is order. but, after that 10525 continue. and again 10679 after starts 20580.

this is hosting website. and local sqlserver also same error . so, please how to order numbers without delete data.

so, please tll me query to solution that error.

please urgent.

try t understanding.

Answers (8)