Reseeding autonumber columns in SQL Server
Here’s one I always have to look up. You’ve cleared out all the data in your tables and you want to set the autoid back to the beginning…or you want to start it at a particular number. DBCC CHECKIDENT is … Continued