Hi,

I have a lot of stored procedures, which joins tables from different server.
The question is: what is the elegant way to manage this situation in case of having development environment, and production environment?

I don`t want to enter 20 stored procedures and manually change linked server or database name?

Thanks for You help!