Erro ao executar as query ;-;

[xxomaskxx 0]

Quando eu vou executar qualquer query do video do flaviohero, da o seguinte erro

Msg 2714, Level 16, State 6, Line 2

There is already an object named 'Agreement' in the database.

Msg 1781, Level 16, State 1, Line 2

Column already has a DEFAULT bound to it.

Msg 1750, Level 16, State 0, Line 2

Could not create constraint. See previous errors.

Alguém pode me ajudar, ;-;

[userjin 3]

Será que você pode colar a Query aqui ao menos?

Vai ficar bem mais fácil de ajudar :v

[xxomaskxx 0]

Será que você pode colar a Query aqui ao menos?

Vai ficar bem mais fácil de ajudar :v

 

Todas estas dão erro :

.

1 - query

 

USE [gc]

GO

 

/****** Object: Table [dbo].[Agreement] Script Date: 01/01/2013 00:06:27 ******/

SET ANSI_NULLS ON

GO

 

SET QUOTED_IDENTIFIER ON

GO

 

CREATE TABLE [dbo].[Agreement](

[login] [nvarchar](20) NOT NULL,

[RegDate] [smalldatetime] NOT NULL,

CONSTRAINT [PK_Agreement] PRIMARY KEY CLUSTERED

(

[login] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]

) ON [PRIMARY]

 

GO

 

ALTER TABLE [dbo].[Agreement] ADD CONSTRAINT [DF_Agreement_RegDate] DEFAULT (getdate()) FOR [RegDate]

GO

 

2 query

 

USE [gc]

GO

 

/****** Object: Table [dbo].[ESantaLimitDate] Script Date: 01/01/2013 00:07:06 ******/

SET ANSI_NULLS ON

GO

 

SET QUOTED_IDENTIFIER ON

GO

 

CREATE TABLE [dbo].[ESantaLimitDate](

[EventUID] [int] NOT NULL,

[LimitDate] [smalldatetime] NOT NULL,

CONSTRAINT [PKC_ESantaLimitDate_EventUID] PRIMARY KEY CLUSTERED

(

[EventUID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]

) ON [PRIMARY]

 

GO

 

ALTER TABLE [dbo].[ESantaLimitDate] WITH CHECK ADD CONSTRAINT [FK_ESantaLimitDate_ESantaEventUID] FOREIGN KEY([EventUID])

REFERENCES [dbo].[ESantaEventUID] ([EventUID])

ON UPDATE CASCADE

ON DELETE CASCADE

GO

 

ALTER TABLE [dbo].[ESantaLimitDate] CHECK CONSTRAINT [FK_ESantaLimitDate_ESantaEventUID]

GO

 

 

3 query

 

USE [gc]

GO

 

/****** Object: Table [dbo].[GMessage] Script Date: 01/01/2013 00:05:30 ******/

SET ANSI_NULLS ON

GO

 

SET QUOTED_IDENTIFIER ON

GO

 

CREATE TABLE [dbo].[GMessage](

[MessageID] [int] NOT NULL,

[Message] [ntext] NOT NULL,

CONSTRAINT [PKC_GMessage_MessageID] PRIMARY KEY CLUSTERED

(

[MessageID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

 

GO

 

4 query

 

USE [gc]

GO

 

/****** Object: Table [dbo].[WIUser] Script Date: 01/01/2013 00:08:00 ******/

SET ANSI_NULLS ON

GO

 

SET QUOTED_IDENTIFIER ON

GO

 

CREATE TABLE [dbo].[WIUser](

[LoginUID] [int] NOT NULL,

[uID] [int] IDENTITY(1,1) NOT NULL,

[supplierUID] [int] NOT NULL,

[issueUID] [int] NOT NULL,

[RegDate] [smalldatetime] NOT NULL,

[supDate] [smalldatetime] NOT NULL,

[supplied] AS (case when ([RegDate] = [supDate]) then 0 else 1 end),

CONSTRAINT [PKC_WIUser_LoginUID_UID] PRIMARY KEY CLUSTERED

(

[LoginUID] ASC,

[uID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]

) ON [PRIMARY]

 

GO

 

ALTER TABLE [dbo].[WIUser] WITH CHECK ADD CONSTRAINT [FK_WIUser_Users] FOREIGN KEY([LoginUID])

REFERENCES [dbo].[users] ([LoginUID])

ON UPDATE CASCADE

ON DELETE CASCADE

GO

 

ALTER TABLE [dbo].[WIUser] CHECK CONSTRAINT [FK_WIUser_Users]

GO

 

ALTER TABLE [dbo].[WIUser] WITH CHECK ADD CONSTRAINT [FK_WIUser_WIIssue] FOREIGN KEY([issueUID])

REFERENCES [dbo].[WIIssue] ([issueUID])

ON UPDATE CASCADE

ON DELETE CASCADE

GO

 

ALTER TABLE [dbo].[WIUser] CHECK CONSTRAINT [FK_WIUser_WIIssue]

GO

 

ALTER TABLE [dbo].[WIUser] WITH CHECK ADD CONSTRAINT [FK_WIUser_WISupplier] FOREIGN KEY([supplierUID])

REFERENCES [dbo].[WISupplier] ([supplierUID])

ON UPDATE CASCADE

ON DELETE CASCADE

GO

 

ALTER TABLE [dbo].[WIUser] CHECK CONSTRAINT [FK_WIUser_WISupplier]

GO

 

Tabela dbo.ClientChecksum

 

INSERT INTO [dbo].[ClientChecksum] (ProtocolVer, Checksum, RegDate)

SELECT 321,0xSeuchecksum,CURRENT_TIMESTAMP