Delete all the rows in the ASYNCHWORKITEMRUNNING table and then, reset the increment counter of the table by using RESEED
command. It is
important that the table is not truncated to avoid data inconsistencies.
Use the command below to
reset the values after rows deletion:
('ASYNCHWORKITEMRUNNING', RESEED, 0)
Where RESEED, 0 means that the next value for the IDENTITY will be 1.
It will increment on each insertion.
can find more information about DBCC CHECKIDENT command in the