create procedure sys.sp_MScreate_zero_identity_constraint
    @subid uniqueidentifier
as
    declare @retcode int
    declare @artid uniqueidentifier
    declare @qualified_table_name nvarchar(517)

    -- change the constraints for identity range managed articles to be such that inserts are not allowed
    declare Carticles CURSOR LOCAL FAST_FORWARD FOR
        select artid from dbo.MSmerge_identity_range where subid = @subid
    FOR READ ONLY
    OPEN Carticles
    FETCH Carticles INTO @artid
    WHILE (@@fetch_status <> -1)
    begin
        select @qualified_table_name = sys.fn_MSmerge_getqualifiedobjname(@artid)
        if @qualified_table_name is not NULL
        begin
            exec @retcode = sys.sp_MSrefresh_idrange_check_constraint
                                    @qualified_table_name,
                                    @artid,
                                    0,
                                    0,
                                    0,
                                    0
            if @@error<>0 or @retcode<>0
            begin
                close Carticles
                deallocate Carticles
                goto Cleanup
            end
        end
        fetch Carticles into @artid
    end
    close Carticles
    deallocate Carticles
    return 0

Cleanup:
    return 1