Chars sumindo muemu s4

Estou tendo problemas com Ms Louis S4 a cada sertão período os chars somente das contas e tem que reiniciar o servidor eu utilizo a Ferrarezi web com as tabelas z_rankpk e z_rankhr se alguém tiver uma solução para isso , isso começou dps q comecei a usar a web Ferrarezi

Código:

---

USE [muonline]
GO
/****** Object:  Trigger [dbo].[Z_PK_HERO]    Script Date: 11/06/2018 06:57:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[Z_PK_HERO] ON [dbo].[Character]
  AFTER UPDATE
  AS
 
  SET NOCOUNT ON
  SET XACT_ABORT ON 


  DECLARE @rank int
  DECLARE @[Only registered and activated users can see links. Click Here To Register...]or int
  DECLARE @char varchar(10)
 
  SELECT @[Only registered and activated users can see links. Click Here To Register...]or = PkCount FROM DELETED
  SELECT @rank = PkCount, @char = Name FROM INSERTED
 
  IF (@rank > 0) and (@rank > @[Only registered and activated users can see links. Click Here To Register...]or)
  UPDATE [dbo].[Character]
  SET Z_RankPK = Z_RankPK + (@rank @[Only registered and activated users can see links. Click Here To Register...]or)
  WHERE Name = @char
  ELSE
  IF (@rank < 0) and (@rank < @[Only registered and activated users can see links. Click Here To Register...]or)
  UPDATE [dbo].[Character]
  SET Z_RankHR = Z_RankHR +  @[Only registered and activated users can see links. Click Here To Register...]or-@rank)
  WHERE Name = @char


  SET NOCOUNT OFF
  SET XACT_ABORT OFF

---

testa essa ai

Como o maniacoo passou....essa trigger que faz o banco travar....