Answers for "how to fix Cannot insert duplicate key in object in sql"

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

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

Posted by: Guest on January-08-2021

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

DBCC CHECKIDENT ('TABLE_NAME_GOES_HERE', NORESEED);

Posted by: Guest on January-08-2021

Code answers related to "how to fix Cannot insert duplicate key in object in sql"