Restart SQL Server Sequence without impact DACPAC

ResetSqlServerSequence.sql

-- Restart sequence to 1, this not impact dacpac

ALTER SEQUENCE MySequence RESTART WITH 1

-- Get all needed id to reach the desidered number, @range_first_value is mandatory
-- and returns the first (minimum or maximum) value of the sequence object used to calculate the requested range. 
--
-- https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-sequence-get-range-transact-sql?view=sql-server-ver16

DECLARE @range_first_value SQL_VARIANT;

EXEC sp_sequence_get_range
    @sequence_name = 'MySequence',
    @range_size = 100,
    @range_first_value = @range_first_value OUTPUT;