quote:

---

Originally posted by X002548

Welcome to SQLTEAM

Please red the link in my sig. And Post What it asks for there

Are you using stored procs?





Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

---

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

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

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

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

CREATE TABLE [jcarterfb].[tblComment] (
	[commentID] [int] IDENTITY (1, 1) NOT NULL ,
	[blogID] [int] NOT NULL ,
	[commentDate] [smalldatetime] NOT NULL ,
	[commentName] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[commentEmail] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[commentURL] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[commentHTML] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[commentInclude] [bit] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [jcarterfb].[tblCategory] (
	[catID] [int] IDENTITY (1, 1) NOT NULL ,
	[catName] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [jcarterfb].[tblBlog] (
	[BlogID] [int] IDENTITY (1, 1) NOT NULL ,
	[CatID] [int] NOT NULL ,
	[BlogHeadline] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[BlogHTML] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[BlogDate] [smalldatetime] NOT NULL ,
	[BlogIncluded] [bit] NOT NULL ,
	[File] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [jcarterfb].[tblComment] WITH NOCHECK ADD 
	CONSTRAINT [PK_tblComment] PRIMARY KEY  CLUSTERED 
	(
		[commentID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [jcarterfb].[tblCategory] WITH NOCHECK ADD 
	CONSTRAINT [PK_tblCategory] PRIMARY KEY  CLUSTERED 
	(
		[catID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [jcarterfb].[tblBlog] WITH NOCHECK ADD 
	CONSTRAINT [PK_tblBlog] PRIMARY KEY  CLUSTERED 
	(
		[BlogID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [jcarterfb].[tblBlog] ADD 
	CONSTRAINT [FK_tblBlog_tblCategory] FOREIGN KEY 
	(
		[CatID]
	) REFERENCES [jcarterfb].[tblCategory] (
		[catID]
	) NOT FOR REPLICATION 
GO

alter table [jcarterfb].[tblBlog] nocheck constraint [FK_tblBlog_tblCategory]
GO