The maximum number of rows you can insert into a table depends on the precision that is 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 bcp to remove the gaps. See “Reaching the IDENTITY column’s maximum value”.
