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?