Hi all - I am a newbie to this forum, but maybe someone there can help.
I have a table using an Identity property. The purpose of it is to just have a unique id value... the problem is that the system automatically fills this table with lots of data, over and over. Certain records get removed and then regenerated. This is fine, but I worry that at some point the Identity value will hit the max (bigint) and then what will happen? I cannot clear the table and start over at any point, and it's not clear if resetting the seed to 0 or 1 will work properly when it is incrementing and finds an existing value. Docs seem to tell you not to reset seed to value below existing value.
Does anyone know what will happen once the identity field hits it's max value? Can I reseed the identity to start over at 1 and fill in the gaps?