DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
NaomiP 10/1/2009 2:08:00 PM

Incorrect syntax near 'INDEX'. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required

Someone recently sent me this error:

Incorrect syntax near 'INDEX'. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required

That they were getting running an aging process in Dynamics GP.

I don't have the script, but when I did some testing of scripts against the Northwind database using SQL 2000, 2005, and 2008 and I discovered that 2008 won't run this script:

 

Version: Unknown or N/A
Section: Dynamics GP