Warning SQL71502 - Procedure <name> has an unresolved reference to object <name>
I'm getting the following warning in my Visual Studio 2013 project:
SQL71502 - Procedure has an unresolved reference to object
Solution
This can be resolved by adding a database reference to the master database.
- Add Database Reference:
- Select the
masterdatabase and click OK:
- Result:
- Display all data when Date Range inputs are null
- Snowflake join on mixed datatypes not returning results
- How to insert a value that contains an apostrophe (single quote)?
- Use Alias from one select to be used in another select
- SQL IN Clause 1000 item limit
- SQL Server: IF EXISTS massively slowing down a query
- SQL-Snowflake - How to count the days between dates in 2 or more rows with WHERE condition
- How to SELECT by MAX(date)?
- Presto sql: presto extract substring for the last occurrence of character in string
- SQL - Select first 10 rows only?
- Operator precedence of `EXISTS`
- mysql create view only if it doesn't already exist
- How to validate data is Hexadecimal in Presto
- Merge tables with different timestamps?
- Wordpress - generate random unique number using atomic operation and update database
- PostgreSQL ERROR: cannot accumulate arrays of different dimensionality
- PostgreSQL copy row minus a few columns
- SQL Server random selection
- SQL to show current PTID and Next_PTID based on my example
- How to add constraint if not exists
- Rolling sum that resets at a flag
- Why is LEFT INNER JOIN deprecated?
- Left outer join on multiple tables condition
- Will the CTE reflect changes in the data?
- incorrect results from MAX and ORDER BY
- Generate CREATE scripts for a list of indexes
- How to create a deterministic uniqueidentifier (GUID) from an integer value
- Why must some stored procedures in MSSQL be called with `master..` prepended while other can be called without it?
- Insert sorted rows in another table using SQL
- Is there a way to prevent ROW_NUMBER's ORDER BY from having to repeat the same thing?