Suppress some warnings in SQL Server SSDT

sql-server sql-server-data-tools
Jason Kresowaty picture Jason Kresowaty · May 31, 2012 · Viewed 17.9k times · Source

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?

Answer

Varun picture Varun · Feb 27, 2014

You can suppress it at individual file level which contains the code generating the warning if you want. Something like this.

<Build Include="Stored Procedures\X.sql">
    <SuppressTSqlWarnings>71502</SuppressTSqlWarnings>
</Build>

Related questions

Visual Studio 2017 does not have Business Intelligence Integration Services/Projects

I do not see an option to create an SSIS project using Visual Studio 2017.

Read More
unresolved reference to object [INFORMATION_SCHEMA].[TABLES]

I've created a UDF that accesses the [INFORMATION_SCHEMA].[TABLES] view: CREATE FUNCTION [dbo].[CountTables] ( @name sysname ) RETURNS INT AS BEGIN RETURN ( SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = @name ); END Within Visual Studio, the schema and name …

Read More
Visual Studio 2013 incompatibility with MS SQL Server 2014

I downloaded MS SQL Server 2014 Enterprise Edition from MSDN. I want to do a server backend in C# and MS SQL, but the problem is, whenever I want to do something with DB in Visual Studio 2013 Ultimate it just tells …

Read More