Incorrect syntax near ','
sql-server, syntax-error
Solution
Remove the ")" in "[ConnectionString] nvarchar NULL),"
Problem
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.