title: What is wrong with this SQL statement syntax? Msg 170, Incorrect syntax near '('
body: <pre><code>USE [WORDDB]
  GO
  
  /****** Object:  Index [noun_minor]    Script Date: 07/03/2013 13:34:21 ******/
  CREATE NONCLUSTERED INDEX [noun_minor] ON [dbo].[2013Words] 
  (
          [NOUN_NO] ASC,
          [MIN_NO] ASC
      )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
      GO
  </code></pre>
  
  <p>I get the error below when parsing the query, SQL Server 2000:</p>
  
  <blockquote>
    <p>Msg 170, Level 15, State 1, Line 7<br>
    Line 7: Incorrect syntax near '('.</p>
  </blockquote>