INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_RF_Task_User_Tasks'. The conflict occurred in database 'Projects', table 'Tasks', column 'TaskID'. The statement has been terminated.

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_RF_User_Project_Projects]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[RF_User_Project] DROP CONSTRAINT FK_RF_User_Project_Projects
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_Tasks_Projects]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[Tasks] DROP CONSTRAINT FK_Tasks_Projects
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_RF_Task_User_Tasks]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[RF_Task_User] DROP CONSTRAINT FK_RF_Task_User_Tasks
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Projects]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Projects]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[RF_Task_User]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[RF_Task_User]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Tasks]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Tasks]
GO

CREATE TABLE [dbo].[Projects] (
	[ProjectID] [int] IDENTITY (1, 1) NOT NULL ,
	[ProjectName] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[ProjectAdded] [datetime] NULL ,
	[ProjectUpdated] [datetime] NULL ,
	[ProjectCompleted] [bit] NULL ,
	[ProjectOwner] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[ProjectDue] [datetime] NULL ,
	[ProjectPriority] [int] NULL ,
	[ProjectGoal] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[ProjectSummary] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[ProjectDescription] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[HasTasks] [bit] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[RF_Task_User] (
	[TaskID] [int] NULL ,
	[UserID] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Tasks] (
	[TaskID] [int] IDENTITY (1, 1) NOT NULL ,
	[ProjectID] [int] NULL ,
	[TaskName] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[TaskDescription] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[TaskAdded] [datetime] NULL ,
	[TaskUpdated] [datetime] NULL ,
	[TaskCompleted] [bit] NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Projects] WITH NOCHECK ADD 
	CONSTRAINT [PK_Projects] PRIMARY KEY  CLUSTERED 
	(
		[ProjectID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Tasks] WITH NOCHECK ADD 
	CONSTRAINT [PK_Tasks] PRIMARY KEY  CLUSTERED 
	(
		[TaskID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Projects] WITH NOCHECK ADD 
	CONSTRAINT [DF_Projects_ProjectCompleted] DEFAULT (0) FOR [ProjectCompleted]
GO

 CREATE  INDEX [IX_RF_Task_User] ON [dbo].[RF_Task_User]([TaskID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Tasks] WITH NOCHECK ADD 
	CONSTRAINT [DF_Tasks_TaskCompleted] DEFAULT (0) FOR [TaskCompleted]
GO

 CREATE  INDEX [IX_Tasks] ON [dbo].[Tasks]([ProjectID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[RF_Task_User] ADD 
	CONSTRAINT [FK_RF_Task_User_Tasks] FOREIGN KEY 
	(
		[TaskID]
	) REFERENCES [dbo].[Tasks] (
		[TaskID]
	) ON DELETE CASCADE  NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[Tasks] ADD 
	CONSTRAINT [FK_Tasks_Projects] FOREIGN KEY 
	(
		[ProjectID]
	) REFERENCES [dbo].[Projects] (
		[ProjectID]
	) ON DELETE CASCADE  NOT FOR REPLICATION 
GO