• So, can we say that what SQL Server does to determine the next identity

    value is:

    Select Sign(Ident_Incr('tablename')) * Max(Sign(Ident_Incr('tablename')) * $IDENTITY) + Ident_Incr('tablename')

    From tablename

    where $IDENTITY is the identity column of table tablename ?