Using SSDT, how do I resolve SQL71561 errors when I have a view that references objects in a different database?

by

To resolve this, I added a reference to the other database, clearing out the “Database variable” field in the dialog. If I didn’t clear this field, when doing a schema compare, SSDT would generate the update script using the database variable name, which would fail.

  1. Add a Database Reference to the project.
  2. In my case the other database was another project in the same solution, so I was able to select it in the first drop down on the “Add Database Reference” dialog.
  3. Make sure the text in the “Database name” field is correct.
  4. Clear out the “Database variable” field.

Look at the “Example usage” text and verify that it looks as expected. Click “OK” to add the reference and that should take care of the ‘unresolved reference’ errors.

After doing this, I was able to do a schema comparison, but trying to build the project produced the following error:

Error 408 SQL00208: Invalid object name ‘db.schema.table’.

Going to the project properties and unchecking “Enable extended Transact-SQL verification for common objects” allowed the project to build successfully.

More Related Contents:

  1. Importing excel files having variable headers
  2. To run a SSIS package outside of SQL Server Data Tools you must install Move File to Archive of Integration Services or higher
  3. Max Nbr of Months W/ No Activity in Past 12 Months
  4. SQL server query to output the data shown below
  5. hide/remove header and footer
  6. Will ANSI JOIN vs. non-ANSI JOIN queries perform differently?
  7. What is the difference between Integrated Security = True and Integrated Security = SSPI?
  8. How to use a variable for the database name in T-SQL?
  9. What is the difference between char, nchar, varchar, and nvarchar in SQL Server?
  10. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  11. Missing artifact com.microsoft.sqlserver:sqljdbc4:jar:4.0
  12. Create a view with ORDER BY clause
  13. What does ‘COLLATE SQL_Latin1_General_CP1_CI_AS’ do?
  14. INSERT INTO vs SELECT INTO
  15. Possible to store value of one select column and use it for the next one?
  16. How to view transaction logs in SQL Server 2008 [closed]
  17. How to write UTF-8 characters using bulk insert in SQL Server?
  18. How can I change from SQL Server Windows mode to mixed mode (SQL Server 2008)?
  19. How can I Insert data into SQL Server using VBNet
  20. Using NOLOCK Hint in EF4?
  21. Will GETUTCDATE() return the same value if used twice in the same statement?
  22. Convert decimal time to hours and minutes
  23. Remove all spaces from a string in SQL Server
  24. Create table (structure) from existing table
  25. SQL Query Where Column = ” returning Emoji characters 🎃 and 🍰
  26. How can I make SQL Server return FALSE for comparing varchars with and without trailing spaces?
  27. How to find a text inside SQL Server procedures / triggers?
  28. How do you open an SDF file (SQL Server Compact Edition)? [closed]
  29. Bootstrapping SQL Express from WiX?
  30. CHECKSUM and CHECKSUM_AGG: What’s the algorithm?

Leave a Comment