The maximum number of rows you can insert into a table depends on the precision set for the IDENTITY column. If a table reaches that limit, you can either re-create the table with a larger precision or, if the table’s IDENTITY column is not used for referential integrity, use the bcp utility to remove the gaps. See “Reaching the IDENTITY column’s maximum value” for more information.
