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

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

     

  • 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

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

  • 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