I’ve deleted some records from a table in a SQL Server database.
The IDs in the table look like this:
99
100
101
1200
1201…
I want to delete the later records (IDs >1200), then I want to reset the auto increment so the next autogenerated ID will be 102. So my records are sequential, Is there a way to do this in SQL Server?
