2008r2 - external references, some databases ignored

baggisterbaggister Posts: 5
edited July 25, 2016 9:20AM in SQL Data Compare 11
sql server 2008r2

I noticed that some databases (external references) were completely ignored. (all settings ticked, all levels, objects uses, objects used by, resolve all external, etc).

After comparing two databases (one that has an SP that was resolved, one that was totally ignored) I noticed that the only difference was a setting called "Cross-database Ownership Chaining Enabled".

This setting was true for the successful external reference, and false for the database that was entirely skipped.

I changed this to True, and it worked. However, Microsoft recommends leaving this as false.

I did notice that there was another database with this setting as false which only appeared in the diagram afterI had clicked "Resolve External References" four or give times.

It's not an obvious or exact science.

Thought I'd mention it.

Comments

  • Eddie DEddie D Posts: 1,802 Rose Gold 5
    Hi

    Thank you for your forum post.

    Are you sure that you have posted in the correct forum?? The question you have asked looks like a SQL Dependency Tracker problem and not a SQL Data Compare problem. Also your question is very similar to this POST submitted by you on the SQL Dependency Tracker forum.

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.