How to Reset an Identity Seed in Microsoft SQL. Sometimes, as when testing a table in a Microsoft SQL Server database, you need to reset an identity column to its initial seed value, typically one.