• Do you have difference lookup tables in the same database with different owners, or are they owned by dbo but in different databases/on different servers?

    Yes.

    he best thing to do is to make sure you qualify all objects with the Schema...

    No. It's not the best thing.