title: CI / TFS and SQL Server database testing : schema validation with unit tests
body: <p>What are best practices to perform the Schema-Validation in SQL Server ?</p>
  
  <p>I need to test whether a views, stored-procedure, trigger of function points to an existent and working table (or any other objects) or not, and need to perform this check against all objects in the database. I'd like to avoid people introducing broken code and validate that overall schema which should be in a consistent state before releasing in production.</p>
  
  <p>Shall i do it within unit-testing ? what is the best approach ?</p>
  
  <p>I am using CI / TFS and Visual Studio 2015.</p>
  
  <p>Thanks!</p>