Alguem me ajuda aqui ?

[maroscalys]

como resolvo esses erros?

(3 row(s) affected)

Server: Msg 2705, Level 16, State 4, Line 2

Column names in each table must be unique. Column name 'motivobloc' in table 'Character' is specified more than once.

Server: Msg 2705, Level 16, State 4, Line 2

Column names in each table must be unique. Column name 'diasdesbloc' in table 'Character' is specified more than once.

Server: Msg 2705, Level 16, State 4, Line 2

Column names in each table must be unique. Column name 'databloc' in table 'Character' is specified more than once.

Server: Msg 2705, Level 16, State 4, Line 2

Column names in each table must be unique. Column name 'blocpor' in table 'Character' is specified more than once.

Server: Msg 2705, Level 16, State 4, Line 2

Column names in each table must be unique. Column name 'diasdesbloc' in table 'Memb_info' is specified more than once.

Server: Msg 2705, Level 16, State 4, Line 2

Column names in each table must be unique. Column name 'databloc' in table 'Memb_info' is specified more than once.

Server: Msg 2705, Level 16, State 4, Line 2

Column names in each table must be unique. Column name 'blocpor' in table 'Memb_info' is specified more than once.

Server: Msg 2705, Level 16, State 4, Line 2

Column names in each table must be unique. Column name 'motivobloc' in table 'Memb_info' is specified more than once.

Server: Msg 2705, Level 16, State 4, Line 2

Column names in each table must be unique. Column name 'Cash' in table 'Memb_info' is specified more than once.

Server: Msg 2705, Level 16, State 4, Line 2

Column names in each table must be unique. Column name 'gold' in table 'Memb_info' is specified more than once.

Server: Msg 2705, Level 16, State 4, Line 2

Column names in each table must be unique. Column name 'sexo' in table 'Memb_info' is specified more than once.

Server: Msg 2705, Level 16, State 4, Line 2

Column names in each table must be unique. Column name 'vencimento' in table 'Memb_info' is specified more than once.

(1 row(s) affected)

Server: Msg 2705, Level 16, State 4, Line 2

Column names in each table must be unique. Column name 'diasdevip' in table 'Memb_info' is specified more than once.

Server: Msg 2705, Level 16, State 4, Line 2

Column names in each table must be unique. Column name 'datavip' in table 'Memb_info' is specified more than once.

(3 row(s) affected)

(3 row(s) affected)

(3 row(s) affected)

Server: Msg 2705, Level 16, State 4, Line 1

Column names in each table must be unique. Column name 'resetao' in table 'Character' is specified more than once.

Server: Msg 2705, Level 16, State 4, Line 1

Column names in each table must be unique. Column name 'Resets' in table 'Character' is specified more than once.

 

[pedromnz]

Isso ai foi rodando query né? hehe. Isso ai não é erro não, só ta te avisando que já existem essas colunas na Character e na MEMB_INFO.

 

[maroscalys]

ss foi rodando a query \/

use [MuOnline]

ALTER TABLE Character

    ADD [Avatar] [varchar] (50) COLLATE Latin1_General_CI_AS NULL

GO

ALTER TABLE Character ADD

    PkRank int NOT NULL CONSTRAINT DF_Character_PkRank DEFAULT 0

GO

ALTER TABLE Character

    ADD [motivobloc] [varchar] (255) COLLATE Latin1_General_CI_AS NULL

GO

ALTER TABLE Character

    ADD [diasdesbloc] [varchar] (255) COLLATE Latin1_General_CI_AS NULL

GO

ALTER TABLE Character

    ADD [databloc] [varchar] (255) COLLATE Latin1_General_CI_AS NULL

GO

ALTER TABLE Character

    ADD [blocpor] [varchar] (255) COLLATE Latin1_General_CI_AS NULL

GO

ALTER TABLE Memb_info

    ADD [diasdesbloc] [varchar] (255) COLLATE Latin1_General_CI_AS NULL

GO

ALTER TABLE Memb_info

    ADD [databloc] [varchar] (255) COLLATE Latin1_General_CI_AS NULL

GO

ALTER TABLE Memb_info

    ADD [blocpor] [varchar] (255) COLLATE Latin1_General_CI_AS NULL

GO

ALTER TABLE Memb_info

    ADD [motivobloc] [varchar] (255) COLLATE Latin1_General_CI_AS NULL

GO

ALTER TABLE Memb_info

    ADD [Password_painel] [varchar] (50) COLLATE Latin1_General_CI_AS NULL

GO

ALTER TABLE Memb_info

    ADD [Cash] [int] DEFAULT 0 NOT NULL

GO

ALTER TABLE Memb_info

    ADD [Gold] [int] DEFAULT 0 NOT NULL

GO

ALTER TABLE Memb_info

    ADD [sexo] [varchar] (50) COLLATE Latin1_General_CI_AS NULL

GO

ALTER TABLE Memb_info

    ADD [nascimento] [varchar] (50) COLLATE Latin1_General_CI_AS NULL

GO

ALTER TABLE Memb_info

    ADD [vencimento] [datetime] NULL

GO

ALTER TABLE Memb_info

    ADD [Acesso] [int] DEFAULT 0 NOT NULL

GO

ALTER TABLE Memb_info

    ADD [diasdevip] [int] DEFAULT 0 NOT NULL

GO

ALTER TABLE Memb_info

    ADD [datavip] [datetime] NULL

GO

ALTER TABLE Guild

    ADD [CastleSiege] [int] DEFAULT 0 NOT NULL

GO

ALTER TABLE Character

    ADD [Punicoes] [int] DEFAULT 0 NOT NULL

GO

ALTER TABLE Character

    ADD [Mensal] [int] DEFAULT 0 NOT NULL

GO

ALTER TABLE Character

    ADD [semanal] [int] DEFAULT 0 NOT NULL

GO

ALTER TABLE Character

    ADD [Resetao] [int] DEFAULT 0 NOT NULL

GO

ALTER TABLE Character

    ADD [Resets] [int] DEFAULT 0 NOT NULL

GO

e ta dando isso tb

Server: Msg 207, Level 16, State 1, Procedure CountCS, Line 12

Invalid column name 'CastleSiege'.

Server: Msg 207, Level 16, State 1, Procedure CountCS, Line 12

Invalid column name 'CastleSiege'.

query

Server: Msg 207, Level 16, State 1, Procedure CountCS, Line 12

Invalid column name 'CastleSiege'.

Server: Msg 207, Level 16, State 1, Procedure CountCS, Line 12

Invalid column name 'CastleSiege'.

 

[robinhsantos]

Amigo quando for criar o topico ja bote no titulo o mesmo para indentificar pos  os outros topicos não indetificado serar deletado  

grato a direção