Dualcore DBA violates Betteridge’s Law of Headlines:
I recently had cause to reseed an identity column on a table in SQL Server, which got me wondering “If we reseed an identity column to a value lower than the existing identity values in the column, could it cause a clash?” Because why wouldn’t you wonder if you can cause something to break, whilst performing a fairly simple task!?
Let’s find out what happens…
Click through for the demonstration.