Suppress Database Project errors and warnings in visual studio 2010

database visual-studio-2010 suppress-warnings
Sumit picture Sumit · Apr 16, 2011 · Viewed 34.6k times · Source

I have an Database project in my application and want to suppress the errors/warnings thrown by this project. .first of all is it possible ?

I think I was not clear with my question, by suppressing I meant that when I build my Solution, the errors(which actually are not errors) are shown in the error list, I just want that all Database project related errors should not be shown in the error list.

I am using VS2010.

thanks in advance

Answer

Rushui Guan picture Rushui Guan · Aug 9, 2012

To surppress a specific warning, go to project properties -> Build.

Type in the warning numbers (i.e. without 'SQL') in comma delimited format in field "Suppress Transact-SQL warnings:".

Related questions

Component OLE DB source has no input

I am new at doing SQL server data tools on VS 2010. However what I try do is: I have created a textfile and imported it as a flatfile I try to connect the flat file (with the green arrow) with …

Read More
How do I fix "incorrect syntax near GO" errors in scripts generated with Microsoft's Database Publishing Wizard?

I've been searching for a "definitive" solution to this for a couple of hours now and can't find out exactly what the problem is so am hoping someone can point me in the right direction. I'm trying to create a …

Read More
Why does my DB project's .dbmdl file change even when I make no changes to the project?

I'm running into a small but weird annoyance that seems to be happening to other people, too (for example, check out the revision history of SEDE). I have a SQL Server 2008 database project in Visual Studio 2010 that works properly. When …

Read More