Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Regarding sql server 2012 identity number gap problem after restarting sql server 2012 RE: Regarding sql server 2012 identity number gap problem after restarting sql server 2012

  • This is a known behavior. I reported it as a bug a while back. Microsoft has supplied a work around. You can enable TraceFlag 272 on your server. There are other workarounds as well. Check out the Connect entry for more information.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning