My Linked Server name and sql query change. Even if I write multiple queries to fulfill all the conditions, I am still left with the linked server name as a variable?

The latest thing is to use four-part name. Can I supply variables to do that job?

We do not want the server locations to be hard coded.

1) Any ideas about that?

2) Do u think sp_addlinkedserver could solve the problem?