0.66.sqldataprovider.sql

BugNET is an issue tracking and project issue management solution built using the ASP.NET web applic

/************************************************************/
/*****              SqlDataProvider                     *****/
/*****	    Version 0.66 Schema Upgrade Script          *****/
/*****                                                  *****/
/***** 												    *****/
/*****      										    *****/
/*****      										 	*****/
/*****                                                  *****/
/************************************************************/


/* BEGIN TRANSACTION */
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
IF EXISTS (SELECT * FROM tempdb..sysobjects WHERE id=OBJECT_ID('tempdb..#tmpErrors')) DROP TABLE #tmpErrors
GO
CREATE TABLE #tmpErrors (Error int)
GO
SET XACT_ABORT ON
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO
BEGIN TRANSACTION
GO


PRINT 'Altering  Existing Objects'
GO

/* Alter Users Table */
EXEC sp_rename 'BugComment.Date', 'CreatedDate', 'COLUMN'
GO
EXEC sp_rename 'BugHistory.Date', 'CreatedDate', 'COLUMN'
GO
EXEC sp_rename 'BugAttachment.Size', 'FileSize', 'COLUMN'
GO
ALTER TABLE Users ADD [IsSuperUser] [bit] NOT NULL CONSTRAINT [DF_Users_IsSuperUser] DEFAULT (0)
GO
ALTER TABLE Users DROP CONSTRAINT DF_Users_RoleID
GO
ALTER TABLE Users DROP COLUMN RoleID
GO
ALTER TABLE Users ALTER COLUMN UserName nvarchar(50) not null
GO
ALTER TABLE Users DROP CONSTRAINT DF__Users__active__0F975522
GO
ALTER TABLE Users ALTER COLUMN [Active] [bit] NOT NULL 
GO
ALTER TABLE Users ADD 
	CONSTRAINT [DF_Users_Active] DEFAULT (0) FOR Active
GO


ALTER TABLE [dbo].[Hardware]  ALTER COLUMN [Name] NVARCHAR(20) NOT NULL
ALTER TABLE [dbo].[Priority]  ALTER COLUMN [Name] NVARCHAR(20) NOT NULL
ALTER TABLE [dbo].[Priority]  ALTER COLUMN [ImageUrl] NVARCHAR(50) NULL
ALTER TABLE [dbo].[Status]  ALTER COLUMN [Name] NVARCHAR(20) NOT NULL
ALTER TABLE [dbo].[Type]  ALTER COLUMN [ImageUrl] NVARCHAR(50) NULL
ALTER TABLE [dbo].[Resolution]  ALTER COLUMN [Name] NVARCHAR(20) NOT NULL
ALTER TABLE [dbo].[OperatingSystem]  ALTER COLUMN [Name] NVARCHAR(20) NOT NULL
ALTER TABLE [dbo].[Environment]  ALTER COLUMN [Name] NVARCHAR(50) NOT NULL
ALTER TABLE [dbo].[Version]  ALTER COLUMN [Name] NVARCHAR(20) NOT NULL
ALTER TABLE [dbo].[BugHistory]  ALTER COLUMN [FieldChanged] NVARCHAR(50) NOT NULL
ALTER TABLE [dbo].[BugHistory]  ALTER COLUMN [OldValue] NVARCHAR(50) NOT NULL
ALTER TABLE [dbo].[BugHistory]  ALTER COLUMN [NewValue] NVARCHAR(50) NOT NULL
ALTER TABLE [dbo].[Bug]  ALTER COLUMN [Summary] NVARCHAR(500) NOT NULL
ALTER TABLE [dbo].[Bug]  ALTER COLUMN [Url] NVARCHAR(500) NOT NULL
ALTER TABLE [dbo].[BugAttachment]  ALTER COLUMN [FileName] NVARCHAR(100) NOT NULL
ALTER TABLE [dbo].[BugAttachment]  ALTER COLUMN [Description] NVARCHAR(80) NOT NULL
ALTER TABLE [dbo].[BugAttachment]  ALTER COLUMN [Type] NVARCHAR(50) NOT NULL
ALTER TABLE [dbo].[Roles]  ALTER COLUMN [RoleName] NVARCHAR(20) NOT NULL
ALTER TABLE [dbo].[Users]  ALTER COLUMN [Password] NVARCHAR(20) NOT NULL
ALTER TABLE [dbo].[Project]  ALTER COLUMN [Name] NVARCHAR(30) NOT NULL
ALTER TABLE [dbo].[Project]  ALTER COLUMN [Description] NVARCHAR(80) NOT NULL
ALTER TABLE [dbo].[Component]  ALTER COLUMN [Name] NVARCHAR(50) NOT NULL
GO

/*
*----------------------------------
* Bug Comment Table
*----------------------------------
*/
ALTER TABLE BugComment ADD Comment1 ntext not null CONSTRAINT DF__Bug__Comment DEFAULT ('')
GO
UPDATE BugComment SET  Comment1 = Comment
GO
If exists (select sc.name From sysobjects so join syscolumns sc on so.id = sc.id where so.name = 'BugComment' and sc.name = 'Comment')
BEGIN
	Alter table BugComment Drop column Comment
END
GO
EXEC sp_rename 'BugComment.Comment1', 'Comment', 'COLUMN'
GO
ALTER TABLE BugComment DROP CONSTRAINT DF__Bug__Comment
GO

/* 
*---------------------------
* Bug Table
*---------------------------
*/
ALTER TABLE Bug ADD Description1 ntext not null CONSTRAINT DF__Bug__Description DEFAULT ('')
GO
UPDATE Bug SET  Description1 = Description
GO
If exists (select sc.name From sysobjects so join syscolumns sc on so.id = sc.id where so.name = 'BugComment' and sc.name = 'Comment')
BEGIN
	Alter table Bug Drop column Description
END
GO
EXEC sp_rename 'Bug.Description1', 'Description', 'COLUMN'
GO
ALTER TABLE Bug DROP CONSTRAINT DF__Bug__Description
GO

/* 
*---------------------------
* Project Table
*---------------------------
*/
ALTER TABLE Project ADD Code nvarchar(3) not null CONSTRAINT DF__Project__Code DEFAULT ('')
GO
ALTER TABLE Project ADD AccessType int not null CONSTRAINT DF__Project__AccessType DEFAULT (2)
GO

/* 
*-------------------------------------------------
*	CREATE NEW TABLES 
*-------------------------------------------------
*/
PRINT 'Creating New Objects'
GO


CREATE TABLE [dbo].[BugTimeEntry] (
	[BugTimeEntryId] [int] IDENTITY (1, 1) NOT NULL ,
	[BugId] [int] NOT NULL ,
	[UserId] [int] NOT NULL ,
	[WorkDate] [datetime] NOT NULL ,
	[Duration] [decimal](4, 2) NOT NULL ,
	[BugCommentId] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[HostSettings] (
	[SettingName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[SettingValue] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Permission] (
	[PermissionId] [int] IDENTITY (1, 1) NOT NULL ,
	[PermissionKey] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[ProjectMailBox] (
	[ProjectMailboxId] [int] IDENTITY (1, 1) NOT NULL ,
	[MailBox] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[ProjectID] [int] NOT NULL ,
	[AssignToUserID] [int] NULL ,
	[IssueTypeID] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[RolePermission] (
	[RolePermissionId] [int] IDENTITY (1, 1) NOT NULL ,
	[RoleId] [int] NOT NULL ,
	[PermissionId] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[UserProjects] (
	[UserId] [int] NOT NULL ,
	[ProjectId] [int] NOT NULL ,
	[UserProjectId] [int] IDENTITY (1, 1) NOT NULL ,
	[CreatedDate] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[UserRoles] (
	[UserRoleId] [int] IDENTITY (1, 1) NOT NULL ,
	[UserId] [int] NOT NULL ,
	[RoleId] [int] NOT NULL 
) ON [PRIMARY]
GO

/* Drop the Existing Roles Table & Re-Add the new one */
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Roles]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[Roles]
GO

CREATE TABLE [dbo].[Roles] (
	[RoleID] [int] IDENTITY (1, 1) NOT NULL ,
	[ProjectID] [int] NOT NULL ,
	[RoleName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[Description] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL 
) ON [PRIMARY]
GO

/* Add Constraints */

ALTER TABLE [dbo].[BugTimeEntry] ADD 
	CONSTRAINT [PK_BugTimeEntry] PRIMARY KEY  CLUSTERED 
	(
		[BugTimeEntryId]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[HostSettings] ADD 
	CONSTRAINT [PK_HostSettings] PRIMARY KEY  CLUSTERED 
	(
		[SettingName]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Permission] ADD 
	CONSTRAINT [PK_Permission] PRIMARY KEY  CLUSTERED 
	(
		[PermissionId]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[ProjectMailBox] ADD 
	CONSTRAINT [PK_ProjectMailBox] PRIMARY KEY  CLUSTERED 
	(
		[ProjectMailboxId]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[RolePermission] ADD 
	CONSTRAINT [PK_RolePermission] PRIMARY KEY  CLUSTERED 
	(
		[RolePermissionId]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Roles] ADD 
	CONSTRAINT [PK__Role__0BC6C43E] PRIMARY KEY  CLUSTERED 
	(
		[RoleID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[UserProjects] ADD 
	CONSTRAINT [PK_UserProjects] PRIMARY KEY  CLUSTERED 
	(
		[UserId],
		[ProjectId]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[UserRoles] ADD 
	CONSTRAINT [PK_UserRoles] PRIMARY KEY  CLUSTERED 
	(
		[UserRoleId]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Bug] ADD 
	CONSTRAINT [FK_Bug_Environment] FOREIGN KEY 
	(
		[EnvironmentID]
	) REFERENCES [dbo].[Environment] (
		[EnvironmentID]
	),
	CONSTRAINT [FK_Bug_Hardware] FOREIGN KEY 
	(
		[HardwareID]
	) REFERENCES [dbo].[Hardware] (
		[HardwareID]
	),
	CONSTRAINT [FK_Bug_OperatingSystem] FOREIGN KEY 
	(
		[OperatingSystemID]
	) REFERENCES [dbo].[OperatingSystem] (
		[OperatingSystemID]
	),
	CONSTRAINT [FK_Bug_Priority] FOREIGN KEY 
	(
		[PriorityID]
	) REFERENCES [dbo].[Priority] (
		[PriorityID]
	),
	CONSTRAINT [FK_Bug_Project] FOREIGN KEY 
	(
		[ProjectID]
	) REFERENCES [dbo].[Project] (
		[ProjectID]
	) ON DELETE CASCADE,
	CONSTRAINT [FK_Bug_Resolution] FOREIGN KEY 
	(
		[ResolutionID]
	) REFERENCES [dbo].[Resolution] (
		[ResolutionID]
	),
	CONSTRAINT [FK_Bug_Status] FOREIGN KEY 
	(
		[StatusID]
	) REFERENCES [dbo].[Status] (
		[StatusID]
	),
	CONSTRAINT [FK_Bug_Type] FOREIGN KEY 
	(
		[TypeID]
	) REFERENCES [dbo].[Type] (
		[TypeID]
	)
GO

ALTER TABLE [dbo].[BugAttachment] ADD 
	CONSTRAINT [FK_BugAttachment_Bug] FOREIGN KEY 
	(
		[BugID]
	) REFERENCES [dbo].[Bug] (
		[BugID]
	) ON DELETE CASCADE 
GO

ALTER TABLE [dbo].[BugComment] ADD 
	CONSTRAINT [FK_BugComment_Bug] FOREIGN KEY 
	(
		[BugID]
	) REFERENCES [dbo].[Bug] (
		[BugID]
	) ON DELETE CASCADE 
GO

ALTER TABLE [dbo].[BugHistory] ADD 
	CONSTRAINT [FK_BugHistory_Bug] FOREIGN KEY 
	(
		[BugID]
	) REFERENCES [dbo].[Bug] (
		[BugID]
	) ON DELETE CASCADE 
GO

ALTER TABLE [dbo].[BugNotification] ADD 
	CONSTRAINT [FK_BugNotification_Bug] FOREIGN KEY 
	(
		[BugID]
	) REFERENCES [dbo].[Bug] (
		[BugID]
	) ON DELETE CASCADE 
GO

ALTER TABLE [dbo].[BugTimeEntry] ADD 
	CONSTRAINT [FK_BugTimeEntry_Bug] FOREIGN KEY 
	(
		[BugId]
	) REFERENCES [dbo].[Bug] (
		[BugID]
	) ON DELETE CASCADE 
GO

ALTER TABLE [dbo].[Component] ADD 
	CONSTRAINT [FK_Component_Project] FOREIGN KEY 
	(
		[ProjectID]
	) REFERENCES [dbo].[Project] (
		[ProjectID]
	) ON DELETE CASCADE 
GO

ALTER TABLE [dbo].[ProjectMailBox] ADD 
	CONSTRAINT [FK_ProjectMailBox_Project] FOREIGN KEY 
	(
		[ProjectID]
	) REFERENCES [dbo].[Project] (
		[ProjectID]
	) ON DELETE CASCADE 
GO

ALTER TABLE [dbo].[RelatedBug] ADD 
	CONSTRAINT [FK_RelatedBug_Bug] FOREIGN KEY 
	(
		[BugID]
	) REFERENCES [dbo].[Bug] (
		[BugID]
	) ON DELETE CASCADE 
GO

ALTER TABLE [dbo].[RolePermission] ADD 
	CONSTRAINT [FK_RolePermission_Permission] FOREIGN KEY 
	(
		[PermissionId]
	) REFERENCES [dbo].[Permission] (
		[PermissionId]
	),
	CONSTRAINT [FK_RolePermission_Roles] FOREIGN KEY 
	(
		[RoleId]
	) REFERENCES [dbo].[Roles] (
		[RoleID]
	)
GO

ALTER TABLE [dbo].[UserProjects] ADD 
	CONSTRAINT [FK_UserProjects_Users] FOREIGN KEY 
	(
		[UserId]
	) REFERENCES [dbo].[Users] (
		[UserID]
	)
GO

ALTER TABLE [dbo].[UserRoles] ADD 
	CONSTRAINT [FK_UserRoles_Roles] FOREIGN KEY 
	(
		[RoleId]
	) REFERENCES [dbo].[Roles] (
		[RoleID]
	),
	CONSTRAINT [FK_UserRoles_Users] FOREIGN KEY 
	(
		[UserId]
	) REFERENCES [dbo].[Users] (
		[UserID]
	)
GO

ALTER TABLE [dbo].[Version] ADD 
	CONSTRAINT [FK_Version_Project] FOREIGN KEY 
	(
		[ProjectID]
	) REFERENCES [dbo].[Project] (
		[ProjectID]
	) ON DELETE CASCADE 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO


/* 
*---------------------------------------------------
*
*	Stored Procedures 
*
*---------------------------------------------------
*/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Attachment_CreateNewAttachment]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Attachment_CreateNewAttachment]
GO

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Component_GetComponentsByProjectId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)