violation of primary key constraint code example
Example 1: Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
DBCC CHECKIDENT ('TABLE_NAME_GOES_HERE', RESEED, ZZZZZ);
Example 2: Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
DBCC CHECKIDENT ('TABLE_NAME_GOES_HERE', NORESEED);