Incorrect syntax near ','.

Question

I get the following error from the SQL Script I am trying to run:

Msg 102, Level 15, State 1, Line 10 Incorrect syntax near ','.

This is the SQL script:

IF NOT EXISTS (SELECT * 
                 FROM dbo.sysobjects 
                WHERE id = OBJECT_ID(N'[dbo].HDDB_DataSource]') 
                  AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [dbo].[HDDB_DataSource](
 [ID] [int] IDENTITY(1,1) NOT NULL,
 [Name] [nvarchar](255) NOT NULL,
 [Type] [nvarchar](50) NOT NULL,
 [XmlFileName] [nvarchar](255) NULL,
 [ConnectionString] [nvarchar](255) NULL),
 CONSTRAINT [PK_DataSource] PRIMARY KEY CLUSTERED 
(
 [ID] ASC
) ON [PRIMARY]
) ON [PRIMARY]
END

I am using SQL Server 2005 if that helps.

Jeff

Answer 1

You appear to have duplicate lines here:

) ON [PRIMARY]
) ON [PRIMARY]

so the braces are not balanced.

Answer 2

Remove the ")" in "[ConnectionString] nvarchar NULL),"

Answer 3

Get rid of the close paren at the end of the ConnectionString column line before the comma and it should work

Answer 4

Duplicates

) ON [PRIMARY]
) ON [PRIMARY]

Answer 5

Remove ), after the last field (before the constraint).

Answer 6

See, the extraneous ) at the end of this line?

 [ConnectionString] [nvarchar](255) NULL),

Answer 7

Remove , from last row [ConnectionString] nvarchar NULL),