A list of servers to set-up as linked servers

• AshaRRichardson2nd

  Mr or Mrs. 500

  Points: 504

  More actions

  March 19, 2009 at 6:54 pm

  #201938

  Hi -

  I have around 90 servers. I have a list of them that could be put in a database table. Here is my question. How do I go about adding 90 or more servers as linked servers without having to do them one by one.

  Thank ou all.

• Jason Crider

  SSCertifiable

  Points: 6019

  More actions

  March 19, 2009 at 7:39 pm

  #963269

  Generate the script one time, dynamic SQL maybe?

  Are you wanting to create that many linked servers on one server or the same linked servers on each of the 90 machines? My apologies for needing clarification.

  MCITP, Database Administrator
  A hodgepodge of Information Technology and Life
  LinkedIn Profile
  My Twitter

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  March 20, 2009 at 3:48 pm

  #963828

  Do you have any login related information in your central database table so tht script can take the login information from there to add each server as a link server by using appropriate logins?

  MJ