Home Forums SQL Server 2012 SQL 2012 - General gaps in the identity column RE: gaps in the identity column

  • February 13, 2014 at 9:11 am

    #1688809

    TheSQLGuru (2/13/2014)

    such as transaction rollbacks.

    Beat me to it.

    If a transaction fails and rolls back, the identity is "lost". It isn't de-incremented as part of the roll back