• yb751 (10/5/2015)


    Well wasn't the original seed value 1?

    IDENT_SEED

    https://msdn.microsoft.com/en-CA/library/ms189834.aspx

    Returns the original seed value (returned as numeric(@@MAXPRECISION,0)) that was specified when an identity column in a table or a view was created.

    DBCC CHECKIDENT

    https://msdn.microsoft.com/en-us/library/ms176057.aspx

    Checks the current identity value for the specified table in SQL Server 2016 and, if it is needed, changes the identity value.

    Oh jeez. I didn't get that. Thx.