Hi,
I recently installed Visual Studio 2019 and have a database project I am working on which I have cloned the Repository from Azure Devops Repos.
I created a test table on the project and then pushed and committed the changes just to make sure it appears on my branch, I then deleted this table and pushed and committed the changes to the branch as it was a test table and not required.
I then amended an existing view to add a new column, I pushed and committed the changed to the branch.
I then went to Azure Devops and created a Pull Request and this was completed.
I then went to the Pipelines and ran an an existing Build Project.
This where it failed with the error message:
2021-01-28T17:02:42.4303138Z ##[error]D:\a\1\s\Database Projects\NEWReporting\NEWReporting\DW Tables\Adm\Table1.sql(0,0): Error SQL72001: File "D:\a\1\s\Database Projects\NEWReporting\NEWReporting\DW Tables\Adm\Table1.sql" does not exist.
Not sure why it is still referencing the table "Table1.sql" as this is deleted from the Project on Visual Studio?
Any Ideas