A WITH Keyword And Parenthesis Are Now Required. SELECT * FROM e_batch (INDEX=ebtgennumber, NOLOCK) Msg 1018, Level 15, State 1, Line 1 Incorrect syntax near 'INDEX'. with(nolock) , (nolock) , nolock differences? up vote 4 down vote favorite. I know with(nolock) and. A WITH keyword and parenthesis are now required. In SQL Server 2005, with some exceptions, table hints are supported in the FROM clause only when the hints are specified with the WITH keyword. Incorrect syntax near ''. 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. Experts Exchange Questions Incorrect syntax near 'index'. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required. Resources for IT Professionals تسجيل الدخول. المملكة العربية السعودية (العربية) Select table with column named “index. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required. 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. SQL Server I'm upgrading our SQL Server 7.0 to SQL Server 2005. Other than the WITH keyword requirement for table hints, are there any other syntax changes?. A WITH keyword and parenthesis are now required. When these table hints are specified without the WITH keyword, the hints should be specified alone.