Quick Reminder: How to Reseed an Identity Column
Our chief statistician really, really, really, really, really hates seeing an identity column starting at something like 635197 after so much testing. I tell him it doesn't really matter but, still, before we release something for the first time to production he just really wants to see that column start at 1. Statisticians, am I right? And, if the chief statistician isn't happy, ain't no one going to be happy. So, this one's for you, Matt. Grabbed from StackOverflow and oh-so-useful. I run this after we blow the data out of a table and just before the final load before production: DBCC CHECKIDENT ('MyTable', RESEED, 0) GO Find the original article at http://stackoverflow.com/questions/21824478/reset-identity-seed-after-deleting-records-in-sql-server.