GilaMonster (7/19/2013)
Migrating a DB does not reseed identities. Check for jobs that may have done so, ask other DBAs, check the max value in the table and compare it to the current identity seed.
Yep!
Ran DBCC CHECKIDENT and the current column value looks like is higher than the current identity value so it will fail because next one is there.
The thing is, I am the only DBA here and I have not reseed the values. I've been told by my Development team that they have not either. So now I'm puzzled now about what or how this was changed.
I'll post later to confirm.