Answers for "Cannot insert duplicate key row in object ‘dbo.Activity’ with unique index ‘IX_Activity_DelegatedToAgencyId’. The duplicate key value is (2)."

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 "Cannot insert duplicate key row in object ‘dbo.Activity’ with unique index ‘IX_Activity_DelegatedToAgencyId’. The duplicate key value is (2)."