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?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • 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.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

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

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