Need Help On MSSQL 2008

[jeromerz]

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

Thank You Very Much

[Rhyder`]

Did you even try to find on sedrika database?

[xTwiLightx]

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

Finish?

[IPbanned]

same problem. Thakns Twilight

[jeromerz]

Originally Posted by xTwiLightx

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

[xTwiLightx]

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

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

[jeromerz]

Originally Posted by xTwiLightx

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.

[yannick2008]

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

[IPbanned]

Thanks for helping guys.
this helps me too.

[jeromerz]

Error Again

 Spoiler

Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'TABLE'.
Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'TABLE'.
Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'TABLE'.