-- @value has to be unicode too.

create procedure sys.sp_MSchange_priority (@subid uniqueidentifier, @value nvarchar(255))
as
    declare @retcode int
    exec @retcode = dbo.sp_MSreplcheck_subscribe
    if @retcode <> 0 or @@error <> 0
        return 1

    update dbo.sysmergesubscriptions set priority = convert(real, @value)
           where subid = @subid