I've added records to a SQL Server database table. The table had a primary key established and the auto-increment identity seed is set to "Yes". This is done mostly because, with SQL Azure, each table must have a primary key and an identity declared.
Nevertheless, because I need to remove certain items from the table, the identification seed for those tables will be disrupted, as will the index column (which is auto-generated with an increment of 1).
How can I reset the identity column after deleting the entries such that the column's sequence is in ascending numerical order?
The identify field is not utilized as a foreign key anywhere in the database.