reference error for views that use synonyms

  • I have one solution that contains multiple database projects. Some of those database projects contain views, that contain synonyms in the view definition, which reference another database in the same solution. Even when I add a database reference, I'm stilling getting reference errors that prevent me from building the solution. Any ideas?

  • Is this problem specific to synonyms, or are you having problems with direct cross-database references too?

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • I think I figured it out, I was having some circular reference problems, I ended up having to build the dac pac of one of the databases and using that as a reference.

  • Well done.

    Circular references are really bad news with DB projects.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply