• The answer ssumes that the column wasn't flagged "not for replication" - I was expecting to see an option "DBCC CheckIdent(

    ,RESEED)" since most of my identity columns have that tag. However, the other options look like jokes, so hard to get it wrong!

    Tom