How can remove all character data in SHARD ?

[TheShinichi]

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

[zikor1337]

USE [SRO_VT_SHARD_INIT]
exec InitializeShardDB

[TheShinichi]

Originally Posted by zikor1337

USE [SRO_VT_SHARD_INIT]
exec InitializeShardDB

Thanks for ur reply.

That 's result after run script:

(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.

[ღ ∂ Ropp]

FK__CharTrijob__Char
FK__InventoryForAvatar__Items
FK__ChestInfo__AccountJID

^-- fix it [[;.

[TheShinichi]

Originally Posted by ღ ∂ropp

FK__CharTrijob__Char
FK__InventoryForAvatar__Items
FK__ChestInfo__AccountJID

^-- fix it [[;.

Tell me how to fix it pls ?

[eminem5]

Originally Posted by TheShinichi

Tell me how to fix it pls ?

she is still learning how :S

[TheShinichi]

Originally Posted by eminem5

she is still learning how :S

Yes yes Teach me pls