In a SQL Server database table, I have removed some records.
The table's IDs are displayed as follows:
99 100 101 1200 1201...
I want to remove the later entries (IDs more than 1200), after which I want to reset the auto-increment so that the 102nd ID will be generated automatically. Since my records are ordered by date, can I do this in SQL Server?