Post reply

A list of servers to set-up as linked servers

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

  • 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

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply