SQL Server : query error

Question

I try creating this table:

CREATE TABLE [dbo].[WEBENGINE_ACTIVE_SESSIONS]
(
    [session_user_id] [int] NOT NULL,
    [session_id] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
    [session_time] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
    [session_ip] [varchar](25) COLLATE Chinese_PRC_CI_AS NOT NULL,

    CONSTRAINT [PK_WEBENGINE_ACTIVE_SESSIONS] PRIMARY KEY CLUSTERED 
    ([session_user_id] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

and I get error:

[Err] 42000 - [SQL Server]Line 10: Incorrect syntax near '('.

Looks like it's due to database compatibility issue. Check here stackoverflow.com/q/2279536/2993606 — SouravA
– SouravA, Commented Feb 20, 2015 at 16:54

Bill Gregg · Accepted Answer · 2015-02-20 17:53:17Z

2

You have to leave WITH (IGNORE_DUP_KEY = OFF) in SQL Server 2000.

Make sure you start with a NEW QUERY window.

edited Feb 20, 2015 at 17:53

answered Feb 20, 2015 at 16:35

Bill Gregg

7,1572 gold badges24 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Debuger Over a year ago

I use MS SQL Server 2000, query analyzer generate error:Server: Msg 170, Level 15, State 1, Line 9 Line 9: Incorrect syntax near '('. I try using navicat, connect to sql server successfuly and in new query get same error.

Collectives™ on Stack Overflow

SQL Server : query error

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related