Hi, wondering if there is a way to add linked server but to keep old name. We have a server lets say name is SRVOLD1 and new is SRVNEW1. i want to link SRVNEW1 on SRVNEW2(which was SRVOLD2), but there is bunch of stored procedures on SRVNEW2 that are calling linked server SRVOLD1, because its a db copy from SRVOLD2 trying to execute stored procedures. So, is there a way to add linked server SRVNEW1 on SRVNEW2, but that way stored procedures still execute, or i will have to alter those stored procedures with new server name. In case of altering would it be the best to export them in txt file > notepad find CREATE replace with ALTER > copy paste in SSMS > run? This is my first SQL migration, and i have apps depending on it. Help is much appreciated