I have a database with a table that has an Identity column. It has worked fine for months. All of a sudden I get duplicate row errors during inserts (complaining that the Identity column is being duplicated). I ran a dbcc CHECKIDENT command and it returned: "current identity value '1', current column value '74155'." I tried dbcc CHECKDB (and even updated statistics) and it didn't fix. Does anybody know how I might resync the Identity column?