error

• Mike Levan

  SSChampion

  Points: 14201

  More actions

  July 2, 2008 at 4:42 pm

  #188905

  SELECT DISTINCT emp

  FROM #tblseat

  INDEX((IX_placing),NOLOCK)

  I get the this error when i exec above sql stament in a proc

  Incorrect syntax near 'INDEX'. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required. See SQL Server Books Online for proper syntax.

• Mahesh Bote

  SSCrazy Eights

  Points: 9107

  More actions

  July 3, 2008 at 12:14 am

  #837618

  [font="Verdana"]

  try this...

  SELECT DISTINCT emp

  FROM #tblseat

  With (index=IX_placing,NOLOCK)

  Mahesh

  [/font]

  MH-09-AM-8694

• noeld

  SSC Guru

  Points: 96590

  More actions

  July 3, 2008 at 9:35 am

  #837945

  Mike Levan (7/2/2008)

  ---

  SELECT DISTINCT emp

  FROM #tblseat

  INDEX((IX_placing),NOLOCK)

  I get the this error when i exec above sql stament in a proc

  Incorrect syntax near 'INDEX'. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required. See SQL Server Books Online for proper syntax.

  This happend when compatibility level of the db = 90.

  
  * Noel