• 
    
    BEGIN TRAN
    DBCC CHECKIDENT('Table1',RESEED,1)
    DBCC CHECKIDENT('Table1',RESEED)
    COMMIT TRAN

    This will reset to the next non-duplicate value. The RESEED option will only reset the next-in-sequence upward, so set to 1, then let the RESEED do it's work.

    -Dan


    -Dan