Identity Value Jumps after restarting SQL Server

Many people ask the question: Why does Identity Value Jump after restarting SQL Server? In this article, we will provide a solution to eliminating this unwanted jumping. It is one of the common FAQs. Let me create a table and insert a new record. If any reason restarts your SQL Server Instance, the identity column will insert … Read more