I have two databases, db1 and db2, running on two different servers, server1 and server2, and db2 has some stored procedures that will modify the table columns on db1.
In these stored procs, we use Linked Servers and fully qualified names to refer to the tables on db1, like
Now, we decided to migrate db1 from server1 to server2. After migration, db1 and db2 will both run on server2.
Do I have to modify each single cross server reference to remove the
[server1]name in the stored procs?
Could we define cross DB or cross server reference through relative path, so we don't need to modify them every time the two databases change server?