Reseed to next Id available in SQL Server

DECLARE @MaxId INT
SELECT
    @MaxId = max([Id])
FROM
    [MyTable] if @MaxId IS NULL
SET
    @MaxId = 0 DBCC CHECKIDENT ('[MyTable]', RESEED, @MaxId)

Leave a Comment

Your email address will not be published. Required fields are marked *