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”