• recommend you create the relevant linked servers, with the same name as in production, just pointing to the equivalent development environment, e.g. you have a system Jacks in production, with a linked server to that system also called Jacks

    In dev, create a linked server named Jacks that connects to the dev environment of the Jacks system.

    this goes a long way in ensuring consistency across the various environments (DEV / UAT / PRD)

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”