Skip to content

"Invalid objects" check fails with cross database calls #13

@toepoke

Description

@toepoke

When running the "Invalid objects" check if a proc (for instance) references an entity on another database (on the same server) the reference is considered invalid/missing.

Consider:

  • DatabaseA
    • Tables
      • MyTable1
  • DatabaseB
    • Procs
      • MyProcB
        begin
        select * from DatabaseA.dbo.MyTable1
        end

When running the "Invalid objects" test the above will fail as no reference to "MyTable1" will be found in the "DatabaseB" database.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions