In my project there is a table in which I add testing data for smoke tests, proceed with some tests, then delete the data I added. The Primary Key on that table is and not null int and has an auto incrementing identity, so after the deletion the highest number is left as it is.
My question is: is there a way to reorganize this number so it can return to the value before my smoke test inserts?
I tried to do Rebuild and Reorganize on the primary key hoping for a miracle but it didn't work.
Remark: I can't drop the Id column and create it again, as the existing data must have the same Ids after my tests.