"Always Recreate Database" deploys by default in VS 2008
I had gotten into the habit in VS 2005 DB Edition of enabling the "Always Re-Create Database" option in database project properties. This allowed me to ensure that the db was being re-created from scratch every time I deployed it. I would only deploy the database locally if I had made changes that I wanted to see, or maybe it would happen when running unit tests if so configured.
I was feeling rather puzzled when VS 2008 kept auto-deploying my database project every time I entered the debugger. However, it turns out that this is due to VS 2008 having a different default value for a setting that prior to today, had never entered my reality: "Only build startup projects and dependencies on Run". All you need to do is check this box, and you're back to only deploying when you want to.
