How can remove all character data in SHARD ?

04/10/2012 12:33 TheShinichi#1

Hi,

I am using vSRO 1.88.

I want to make a very very very clean db so I try to truncate all characters related tables in SHARD db but Forien key occurs. I can't to drop and re-create tables because fear db crashed !

Tell me any idea !

Thanks :)

04/10/2012 12:35 zikor1337#2

Code:

USE [SRO_VT_SHARD_INIT]
exec InitializeShardDB

04/10/2012 13:34 TheShinichi#3

Quote:
Originally Posted by zikor1337
Code:
USE [SRO_VT_SHARD_INIT]
exec InitializeShardDB

Thanks for ur reply.

That 's result after run script:

Code:

(4 row(s) affected)
Msg 547, Level 16, State 0, Procedure InitializeShardDB, Line 16
The DELETE statement conflicted with the REFERENCE constraint "FK__CharTrijob__Char". The conflict occurred in database "SRO_VT_SHARD", table "dbo._CharTrijob", column 'CharID'.
The statement has been terminated.
Msg 547, Level 16, State 0, Procedure InitializeShardDB, Line 20
The DELETE statement conflicted with the REFERENCE constraint "FK__InventoryForAvatar__Items". The conflict occurred in database "SRO_VT_SHARD", table "dbo._InventoryForAvatar", column 'ItemID'.
The statement has been terminated.
Msg 547, Level 16, State 0, Procedure InitializeShardDB, Line 22
The DELETE statement conflicted with the REFERENCE constraint "FK__ChestInfo__AccountJID". The conflict occurred in database "SRO_VT_SHARD", table "dbo._ChestInfo", column 'JID'.
The statement has been terminated.

04/10/2012 17:19 ღ ∂ Ropp#4

FK__CharTrijob__Char
FK__InventoryForAvatar__Items
FK__ChestInfo__AccountJID

^-- fix it [[;.

04/10/2012 18:43 TheShinichi#5

Quote:

Originally Posted by ღ ∂ropp

FK__CharTrijob__Char
FK__InventoryForAvatar__Items
FK__ChestInfo__AccountJID

^-- fix it [[;.

Tell me how to fix it pls ? :confused:

04/10/2012 19:39 eminem5#6

Quote:

Originally Posted by TheShinichi

Tell me how to fix it pls ? :confused:

she is still learning how :S

04/11/2012 01:17 TheShinichi#7

Quote:

Originally Posted by eminem5

she is still learning how :S

Yes yes :D Teach me pls :D