Post reply

How can I transfer registered servers in Enterprise Manager to SQL Server 2005?

  • April 26, 2007 at 7:00 am

    #173107

    Hi,

    How can I transfer all of my registered SQL Servers from Enterprise Manager in SQL Server 2000 to SQL Server 2005's Management Studio? Can someone help me with this as I have more than 80 registered servers and I don't want to re-register each one under Management Studio in SQL Server 2005.

    Thanks.

     

  • April 26, 2007 at 7:59 am

    #702610

    Bring up the Registered Servers view in Management Studio then right click in the window and select "Previously Registered Servers". This will import the registered servers and groups from Enterprise Manager.

    Better then re-entered all those server.

    David

  • April 26, 2007 at 10:36 am

    #702682

    Thanks David for the reply. It worked and saved me a lot of manual work.

  • April 26, 2007 at 1:05 pm

    #702760

    Glad I could help.

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

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