If identity column is of type 'int' we can address upto 2147483647 after that if we want to insert a new record it throws an exception
Msg 8115, Level 16, State 1, Line 2
Arithmetic overflow error converting IDENTITY to data type int.
Arithmetic overflow occurred.
what is the alternate method for continuing the insertion of new records