sqlquantumleap.com
How Does DBCC CHECKIDENT Really Work When Resetting the Identity Seed (RESEED)?
Does resetting an Identity Seed to a specific value via DBCC CHECKIDENT(…, RESEED, new_seed_value) work the way the documentation states? It depends 🙃