Slava Murygin shows how to point a linked server to a new host:
In my example my linked server has an IP addressed name “192.168.1.103” and pointed to the same SQL Server host.
If we want to redirect that linked server to another SQL Server host we can do following:
April Fool’s Day joke, anybody?