حصريااا Change Name Scroll after Fix

[™Dev Microsoft™]

Welcome Dear S4A Members

Today I Get Qeury Change name Scroll After Fix

here :d
[SPOILER]

USE [PS_GameData] GO  ALTER TABLE Chars ALTER COLUMN [UserID] [varchar](12) COLLATE Chinese_PRC_Stroke_CI_AS NOT NULL ALTER TABLE Chars ALTER COLUMN [OldCharName] [varchar](30) COLLATE Chinese_PRC_Stroke_CI_AS NULL GO  DROP INDEX IX_Chars_CharName ON PS_GameData.dbo.Chars GO  ALTER TABLE Chars ALTER COLUMN [CharName] [varchar](30) COLLATE Chinese_PRC_Stroke_CI_AS NOT NULL GO  USE [PS_GameData] GO /****** Object: Index [IX_Chars_CharName] Script Date: 03/28/2010 10:17:12 ******/ CREATE NONCLUSTERED INDEX [IX_Chars_CharName] ON [dbo].[Chars] ( [CharName] ASC )WITH (PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY] GO  set ANSI_NULLS ON set QUOTED_IDENTIFIER OFF GO

[/SPOILER]

Finnaly I also found one line in a procedure that was uncommented which probably was causing trouble

here :d
[SPOILER]

ALTER   Proc [dbo].[usp_Save_Char_Name_E]  @ServerID tinyint, @CharID int, @OldCharName nvarchar(30), @NewCharName nvarchar(30)  AS  SET NOCOUNT ON --SET XACT_ABORT ON  --DECLARE @NameCnt int --DECLARE @Ret int  SET @OldCharName = LTRIM(RTRIM(@OldCharName)) SET @NewCharName = LTRIM(RTRIM(@NewCharName))  --SET @Ret = 0  IF EXISTS ( SELECT CharID FROM Chars WHERE CharName=@NewCharName AND Del=0) BEGIN 	RETURN -2 END  --BEGIN TRANSACTION  UPDATE Chars SET CharName=@NewCharName,RenameCnt=RenameCnt-1,OldCharName=@OldCharName WHERE CharID=@CharID AND Del=0 IF @@ERROR <> 0 BEGIN 	GOTO ERROR_ROLLBACK END  UPDATE Guilds SET MasterName=@NewCharName WHERE MasterCharID=@CharID --IF @@ERROR <> 0 --BEGIN --	GOTO ERROR_ROLLBACK --END UPDATE FriendChars SET FriendName=@NewCharName WHERE FriendID=@CharID --IF @@ERROR <> 0 --BEGIN --	GOTO ERROR_ROLLBACK --END UPDATE BanChars SET BanName=@NewCharName WHERE BanID=@CharID --IF @@ERROR <> 0 --BEGIN --	GOTO ERROR_ROLLBACK --END INSERT INTO CharRenameLog( ServerID, CharID, CharName) VALUES(@ServerID, @CharID, @NewCharName ) --UPDATE PS_USERDB01.PS_UserData.dbo.CreatedChars SET CharName=@NewCharName WHERE ServerID=@ServerID AND CharID=@CharID --IF @@ERROR <> 0 --BEGIN --	GOTO ERROR_ROLLBACK --END  --COMMIT TRANSACTION RETURN 1   ERROR_ROLLBACK: --ROLLBACK TRANSACTION RETURN -2    SET NOCOUNT OFF

[/SPOILER]

منقول :)

بالتوفيق للجيمع ,,,