Microsoft Office 2010 using an .adp file to connect to a SQL Server 2008 R2.
When trying to make modifications (increasing column size, setting/removing PK's/identity) we randomly come across the following error:
ADO error: Incorrect syntax near 'TABLOCKX'. 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 did not start occurring until these databases were moved from SQL Server 2005 (and upgraded using RESTORE) to SQL Server 2008