title: What is wrong with my create table SQL?
body: <p>I am using SQL Server 2008 management studio to execute the following SQL statements, and here is the related error message from SQL Server management studio. Any ideas what is wrong?</p>
  
  <pre><code>SET ANSI_NULLS ON
  GO
  
  SET QUOTED_IDENTIFIER ON
  GO
  
  Create TABLE [dbo].[BatchStatus](
      [BatchID] [uniqueidentifier] NOT NULL CONSTRAINT [PK_BatchStatus_ID],
      [BatchStatus] [int] NULL,
      CONSTRAINT [PK_BatchStatus_ID] PRIMARY KEY CLUSTERED 
      (
          [BatchID] ASC
      )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
  ) ON [PRIMARY]
  
  GO
  
  
  
  Msg 102, Level 15, State 1, Line 3
  Incorrect syntax near ','.
  Msg 319, Level 15, State 1, Line 8
  Incorrect syntax near the keyword 'with'. If this statement is a common table
  expression, an xmlnamespaces clause or a change tracking context clause, the 
  previous statement must be terminated with a semicolon.
  </code></pre>