Unresolved reference to Synonym RRS feed

  • Question

  • I have created a VS2012 database project from a database containing synonyms. I built a database reference to the database project containing the objects referenced in the synonyms in the first project. But when I perform a build on this project, it returns errors saying, "unresolved reference to object". 

    I searched many online resources, all saying the same thing: add a database reference. That having been done, the errors persist. The synonym resides in the same database with the view (I did not design this database).

    It is my opinion that Visual Studio cannot recognize synonyms in SQL Server 2008R2. Has anyone been successful getting this to work?

    Monday, February 9, 2015 7:55 PM