Doesn't drop items when deploying to Scripts folder
When we deploy changes from a database to a Scripts folder containing a Visual Studio solution with sub-projects, any objects to be dropped aren't handled correctly.
Instead of deleting the .sql file for the dropped object and removing the reference from the .sqlproj, the contents of the .sql file are removed leaving a zero-size file. The object still appears in Visual Studio.
We have to delete the file and reference ourselves.