I am trying to build a database project where I was trying to create a system-versioned table within my Visual Studio 2017 solution, but I am suddenly getting an error:
SQL46010: Incorrect syntax near ]
Normally, that would be a simple fix....except the file it refers to doesn't exist! When I double-click the error within the Error List, I get:
Cannot find file 'MSSQL::dbo.TestHISTORY'
The table it refers to is one that I had named as part of the SYSTEM_VERSIONING = ON (minus the MSSQL:: prefix) command for another table I created. I have restarted Visual Studio, reverted all the changes I made to the database project, restarted my PC, performed a Clean operation against the project but all to no avail!
Has anyone else come up against this error?
I managed to fix this problem by deleting the .jfm and .dbmdl files from the root directory for the database project. After restarting Visual Studio the database project would finally build!