The deployment of a database project is in the wrong order. A script that vsdbcmd.exe created creates first the views, but the triggers on the views are created in (i think) alphabetical order.It can happen that a trigger on 1 view is needed to make another trigger on another view work. This is because a view can have multiple base-tables which needs a trigger to properly perform/allow an update-statement. When the trigger is scripted later, the deploy will fail... The error-message is:View or function 'dbo.vFoo' is not updatable because the modification affects multiple base tables.
Visual Studio/Team Foundation Server/.NET Framework Tooling Version
Steps to reproduce
Operating System Language