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: