Need Help On MSSQL 2008

02/03/2013 14:02 jeromerz#1

Hello Guys,

Can u help me on my problem im not familiar using MSSQL 2008 i kinda need to truncate this dbo.tbl files in Character_DBF

dbo.tblCombatInfo
dbo.tblCombatJoinPlayer
dbo.tblCombatJoinGuild

I already tried to delete it but no effect :(

So any one nice that could teach me how to truncate those 3 items so that i can reset the siege rankings :D

Thank You Very Much

02/03/2013 15:14 Rhyder`#2

Did you even try to find on sedrika database?

02/03/2013 15:26 xTwiLightx#3

Code:

TRUNCATE TABLE dbo.tblCombatInfo
GO
TRUNCATE TABLE dbo.tblCombatJoinPlayer
GO
TRUNCATE TABLE dbo.tblCombatJoinGuild
GO

Finish?

02/04/2013 11:57 IPbanned#4

same problem. Thakns Twilight :)

02/05/2013 04:08 jeromerz#5

Quote:

Originally Posted by xTwiLightx

Code:

TRUNCATE TABLE dbo.tblCombatInfo
GO
TRUNCATE TABLE dbo.tblCombatJoinPlayer
GO
TRUNCATE TABLE dbo.tblCombatJoinGuild
GO

Finish?

Msg 4701, Level 16, State 1, Line 1
Cannot find the object "tblCombatInfo" because it does not exist or you do not have permissions.
Msg 4701, Level 16, State 1, Line 1
Cannot find the object "tblCombatJoinPlayer" because it does not exist or you do not have permissions.
Msg 4701, Level 16, State 1, Line 1
Cannot find the object "tblCombatJoinGuild" because it does not exist or you do not have permissions.

error

02/05/2013 13:47 xTwiLightx#6

Quote:

Originally Posted by jeromerz

Msg 4701, Level 16, State 1, Line 1
Cannot find the object "tblCombatInfo" because it does not exist or you do not have permissions.
Msg 4701, Level 16, State 1, Line 1
Cannot find the object "tblCombatJoinPlayer" because it does not exist or you do not have permissions.
Msg 4701, Level 16, State 1, Line 1
Cannot find the object "tblCombatJoinGuild" because it does not exist or you do not have permissions.

error

:facepalm:

Code:

TRUNCATE TABLE CHARACTER_01_DBF.dbo.tblCombatInfo
GO
TRUNCATE TABLE CHARACTER_01_DBF.dbo.tblCombatJoinPlayer
GO
TRUNCATE TABLE CHARACTER_01_DBF.dbo.tblCombatJoinGuild
GO

02/08/2013 04:02 jeromerz#7

Quote:

Originally Posted by xTwiLightx

:facepalm:

Code:

TRUNCATE TABLE CHARACTER_01_DBF.dbo.tblCombatInfo
GO
TRUNCATE TABLE CHARACTER_01_DBF.dbo.tblCombatJoinPlayer
GO
TRUNCATE TABLE CHARACTER_01_DBF.dbo.tblCombatJoinGuild
GO

Msg 4712, Level 16, State 1, Line 1
Cannot truncate table 'CHARACTER_01_DBF.dbo.tblCombatInfo' because it is being referenced by a FOREIGN KEY constraint.
Msg 4712, Level 16, State 1, Line 1
Cannot truncate table 'CHARACTER_01_DBF.dbo.tblCombatJoinGuild' because it is being referenced by a FOREIGN KEY constraint.

02/08/2013 14:50 yannick2008#8

DELETE TABLE CHARACTER_01_DBF.dbo.tblCombatInfo
GO
DELETE TABLE CHARACTER_01_DBF.dbo.tblCombatJoinPlayer
GO
DELETE TABLE CHARACTER_01_DBF.dbo.tblCombatJoinGuild
GO

02/10/2013 11:42 IPbanned#9

Thanks for helping guys. :)
this helps me too.

02/13/2013 01:23 jeromerz#10

Error Again :(

Spoiler