Warning SQL71502 - Procedure <name> has an unresolved reference to object <name>

sql sql-server visual-studio visual-studio-2015 database-project
Nicholas picture Nicholas · Apr 28, 2015 · Viewed 11.8k times · Source

I'm getting the following warning in my Visual Studio 2013 project:

SQL71502 - Procedure has an unresolved reference to object

Warning SQL71502

Answer

Nicholas picture Nicholas · Apr 28, 2015

This can be resolved by adding a database reference to the master database.

  1. Add Database Reference:

Add DB reference

  1. Select the master database and click OK:

Select database

  1. Result:

Result

Related questions

#region functionality in SSMS 2008

Using Sql Server 2008, is there any functionality similar to #region in Visual Studio? I'm aware that nodes appear to allow collapsing of SQL segments, but as far as I know, this is based on the syntax of the SQL statement. …

Read More
SQL Server project executing multiple script post deploy

I have a SQL Server 2008 DB Project, and want to execute multiple scripts, in order, on post deploy. I've added a PostDeploy.Sql script to a scripts folder, and marked that as PostDeploy, and that works fine. I'm aware that …

Read More
Do I need a database reference for a linked server in a SQL Server database project?

In my database project, I have added a reference to a linked server. When I use this linked server in a view and try to build my database project, SSDT reports errors because it cannot understand references to any of …

Read More