Reseed/Reset Table Identity Value

DBCC CHEKIDENT Used To Reset Your Table Value
For Example

    If  We Want Next Record To Have Identity As 135 We Need To Run Sql Query To :

DBCC CHECKIDENT (yourTABLEname, reseed, 134)

                                                             For More Details Visit Microsoft Tech Lab