Code
SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO/****** Object: Stored Procedure dbo.uspDeleteCouple Script Date: 03/12/2009 19:27:05 ******/ALTER PROCEDURE [dbo].[uspDeleteCouple] @serverindex char(2), @idHusbandOrWife char(7)ASSET NOCOUNT ONdeclare @cid intdeclare @idFirst intdeclare @idSecond intselect @cid = cid from tblCouplePlayer where idPlayer = @idHusbandOrWifeselect @idFirst = max(idPlayer) from tblCouplePlayer where cid = @cid and nServer = @serverindexselect @idSecond = min(idPlayer) from tblCouplePlayer where cid = @cid and nServer = @serverindexdelete from tblCouplePlayer wherenServer = @serverindexAND(idPlayer = @idFirstORidPlayer = @idSecond)delete from tblCouple wherenServer = @serverindexANDcid = @cidSET NOCOUNT OFFGOSET ANSI_NULLS OFFGOSET QUOTED_IDENTIFIER OFFGOCouple System Fix Procedure.
Mehr muss man dazu ja nicht sagen
Have fun && Fix !
LG Time2Chill
Quelle: Dragonlord im Ragezone-Forum // http://forum.ragezone.com/f457/quick-cou…tem-fix-627176/