Suppress some warnings in SQL Server SSDT

sql-server, sql-server-data-tools

Solution

You weren't clear on what would determine which 71502 messages would be suppressed and which ones wouldn't but based on my own understanding and research I think the answer is the same. In short, no.

You can suppress all warnings, or warnings based on a specific code ( 71502 ) but that is as granular as it gets.

http://msdn.microsoft.com/en-us/library/hh272681(v=VS.103).aspx

This link talks about promoting warning to errors but also demonstrates how the suppress filter is used - which based on your question you probably already know.

http://social.msdn.microsoft.com/Forums/is/ssdt/thread/9b698de1-9f6d-4e51-8c73-93c57355e768

Problem

In SQL Server Data Tools, I would like to suppress some, but not all, occurrences of SQL71502 ("--- has an unresolved reference to object ---"). I know I can suppress through Project Properties, Build, Suppress Transact-SQL warnings, but this will globally suppress. Can this be done?

Original source