I have a ms sql table with 3 columns: id (pk), sku and quantity.

Once a day this table is truncated, then populated with new data. Every time new data goes in, the auto increment id never starts at 1, it keeps incrementing, starting at the highest + 1 pre-truncated id value.

My question is, will it ever stop incrementing, causing insert of new data to stop?