Post reply

SQL Server Registration in SQL server Studio 2005

  • January 17, 2006 at 8:53 am

    #170563

    We recently started to use SQL server Studio to manage all our SQL servers (More than 250) Not all the server are in 2005 yet.  If there a way to transfer the entire SQL server registrations in EM 2000 to SQL server Studio?  It takes a lot of time to register each server manually.

    Thank You,

            Rafael Colón

     

      

  • January 18, 2006 at 7:08 am

    #615468

    If I remember correctly, right click on Database Engine in the Registered Servers window and the menu should have "Previously Registered Servers" in it. Any SQL 2000 servers that were  registered on that machine will be imported. You can export that new 2005 list of registered servers to file and distribute it.

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

  • February 8, 2006 at 10:55 am

    #619585

    This is excellent!!

     

    Thanks for your Tip

     

    Rafael

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

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