error in table creation - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

error in table creation

Author

Topic

putane.sanjay
Yak Posting Veteran

77 Posts

Posted - 2007-02-14 : 12:19:35

CREATE TABLE [dbo].markemptot(

[id] [char](11) COLLATE Latin1_General_BIN NOT NULL,

[cdate] [float] NOT NULL,

[ctime] [float] NOT NULL,

[coper] [char](8) COLLATE Latin1_General_BIN NOT NULL,

[tfile] [varchar](255) COLLATE Latin1_General_BIN NOT NULL,

[data] [text] COLLATE Latin1_General_BIN NULL,

CONSTRAINT [markemptot_id] PRIMARY KEY CLUSTERED

(

[id] ASC,

[cdate] ASC,

[ctime] ASC

)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

iam getting error to create table.

Kristen
Test

22859 Posts

Posted - 2007-02-14 : 13:42:18

IGNORE_DUP_KEY

Not seen that before.

Kristen

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2007-02-14 : 14:02:41

This is valid on constraints in SQL Server 2005 only, not SQL Server 2000:
WITH IGNORE_DUP_KEY = OFF

In SQL Server 2000, it is only allowed on a CREATE INDEX.

CODO ERGO SUM

putane.sanjay
Yak Posting Veteran

77 Posts

Posted - 2007-02-15 : 02:01:11

yes ,this script is written in sql server 20005 but i want to create same table in sql server 2000. please help me

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-02-15 : 02:04:48

remove the