• Ansharah (9/28/2016)


    If know clear root cause of this problem. I can avoid in future since its in Prod.

    Like I said, someone reseeded the identity. Since you need sysadmin, db_owner or db_ddladmin to run DBCC CHECKIDENT, make sure you control membership of those roles. Also, consider setting up something (extended events, for example) that will capture and record DDL changes to your database. You can write that yourself or buy something in.

    John