Set up database project for compiler error validation

Database projects in Visual Studio can significantly improve your development team's ability to manage database code. But it's important to set up compiler error checking correctly, otherwise many errors can get missed until you're deploying code.

Follow these steps for every database project in your solution: