Return
-
Title
"[Incorrect syntax near 'WHERE']...] " parse error is encountered when trying to synchronize two database -
Description
Steps to reproduce the issue:
- Open SSMS
- create a new database
- create a "member" scheme in the newly created database
- for a newly created database open a new query
- copy and paste statements from the attached FULL_object.txt in the new query window and click on the execute button
- Open ApexSQL Diff and for the Source choose a newly created database while on the Destination side create an empty database and click on the Compare button
- Choose Synchronize button
- "Error is encountered ..." message will appear
-
Resolution
WORKAROUND
Do not use NOLOCK before WHERE, because currently it is not supported by the grammar