View Full Version : Chars sumindo muemu s4
MuSoul
11/06/2018, 03:11 AM
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
maniacoo
11/06/2018, 07:29 AM
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
[Only registered and activated users can see links]
DECLARE valor int
[Only registered and activated users can see links]
SELECT valor = PkCount FROM DELETED
[Only registered and activated users can see links]
[Only registered and activated users can see links]
UPDATE [dbo].[Character]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
ELSE
[Only registered and activated users can see links]
UPDATE [dbo].[Character]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
SET NOCOUNT OFF
SET XACT_ABORT OFF
testa essa ai
louis
11/06/2018, 09:58 PM
Como o maniacoo passou....essa trigger que faz o banco travar....
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.