One of the things we did at the end of the product cycle, when we decided that we need to allow you to filter out warnings, is to clean up all error and warning messages and concisely group them in to specific buckets. Understanding these buckets will go a long way helping you interpret the cause of the warnings and errors.
Lets look at some of the categories and some examples:
Phase 2 parsing errors, are always syntax related!
As you can see the biggest bucket is the 30xx section, raised during the interpretation of the T-SQL code. Some of the warnings are there to inform you, for example when you are referencing an object that is outside the scope of the project. If you want to filter out a specific category you can do so in the Build project property page.
NOTE: Filtering out warnings will only suppress the warning message(s) and does not resolve the the cause
In a next blog post I will create continue the subject by using a demo project I created that shows the various forms of ambiguity, stay tuned.