thanks for your replies..

i ran the following query:

select min(stats_ID) as min_id, max(stats_id) as max_id, Count(stats_ID) as total from The_maxed_out_table

currently the table is like this..

min ID = 308,673,131

max ID = 2,146,014,757 (a few rows can be inserted, but no bulk inserts)

current row count = 151,551,037

so i guess i can re-seed from 1 again...

DBCC CHECKIDENT ("The_maxed_out_table", RESEED, 1);

would this work?