Answers for "violation of unique key constraint cannot insert duplicate key in object the duplicate key value is"

Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).

DBCC CHECKIDENT ('TABLE_NAME_GOES_HERE', RESEED, ZZZZZ);

Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).

DBCC CHECKIDENT ('TABLE_NAME_GOES_HERE', NORESEED);