TransWikia.com

Warning SQL71502 - Procedure has an unresolved reference to object

Stack Overflow Asked on November 24, 2021

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

SQL71502 – Procedure has an unresolved reference to object

Warning SQL71502

3 Answers

Nicholas' answer put me on the right track, but did not fix the issue for me because I had an existing database reference to "master" which was left over from a legacy development environment and SQL server installation.

Deleting this (broken) reference and then re-adding it following Nicholas' instructions worked for me. Note that the "Suppress errors caused by unresolved references..." box wasn't checked by default in VS2019; I had to check that manually.

Answered by Eric Hirst on November 24, 2021

You just have to set 71502 in the field Buid/Suppress Transact-SQL warning :

See picture in the link

Answered by didaskein on November 24, 2021

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

Answered by Nic on November 24, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP