• Is there a chart somewhere that shows the maximum number of identity values for the data type used when creating an identity field in a table?

    I've searched for this in the BOL but have not had any luck.

    We had someone design tables in a database to use the an identity column of datatype int for the orders and line item sequence numbers.

    If the seed value is 40,000,000 for orders with an increment of 1, how many orders can be created before the field has reached maximum value?

    Thank you.