Identity column value suddenly jumps to 1000 in sql server

Discussion in 'Databases' started by edotsolutions, Jan 15, 2020.

  1. At the beginning Identity column starts from 1,2 and so on and adding identity smoothly,
    but suddenly it jumps to 1001,1002 and onwards. What could be the reason? Please assist.
     
  2. Elshadriel

    Elshadriel Winhost Staff

    Please open up a support ticket to have it corrected. It happens sometimes when SQL Server restarts due to a server update.
     

Share This Page