Displaying posts tagged with

“Identity crisis in SQL Server 2012”

Identity reseed in SQL Server 2012

Identity reseed in SQL Server 2012 In SQL Server 2012, there is one issue regarding Identity column. I have faced identity value is jumping by 1000 when i have restarted my SQL Server Service. You can find gaps in identity while you restart your sql server service, restart of server or failover. Please review below code to [...]