-- @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