• 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?