Database Deployment Problems

I am working for a team at Red Gate charged with helping to prevent database deployment issues. It is important that we understand real-world problems so we can try to prevent deployment issues within our tooling.

Please help us by taking five minutes of your time to describe any issues you have encountered.

Many thanks,
David.Atkinson@red-gate.com

Question Title

* 1. Please describe the last problem you encountered when deploying changes from development through to production. Please tell us what caused the problem and how it could have been avoided.

Question Title

* 2. If different from your previous answer, please describe the most typical problem you encounter when deploying changes from development through to production.