Resolve SQL Server Identity Jumping 1000 Issue, resolve with DENTITY_CACHE

In SQL Server time we faced an issue with the Identity field, It directly jumps with 1000 numbers. So in this article, we resolve this issue. What to do suppose your last entry put with Jumped value. Copy your last row data somewhere in notepad Remove last row The above code will reset your seed … Read more