I've got a composite database project in VS2010 that contains two projects A and B, where project B references project A. Project A has got the Always re-create database option set and project B doesn't.
Basically deploy the project direct towards the database the project deploys effectively and 2 deployment scripts A.sql and B.sql are produced. I'm able to then begin using these scripts to recreate the database.
If however I alter the Deploy action of both projects to Produce a deployment script, B.sql will contain code to decrease and recreate the database.
Basically disable the Always re-create database option in project A, the drop and recreate is going to be taken off both A.sql and B.sql, leading to no database being produced.
Any applying for grants the way i can get this work?