• It looks to be an issue with cross database chaining..to fix it you will need to run the script below on both databases:

    ALTER DATABASE db SET DB_CHAINING ON

    The_SQL_DBA
    MCTS

    "Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."