Post reply

SQL 2008 Management Studio - Registering SQL Instances across a domain & saving the list

  • August 22, 2008 at 11:50 am

    #197467

    I'm kind of new to SQL 2008 - our company went directly from SQL 2000 to 2008 and we finished rolling it out this week.

    I was wondering if anyone knows how to save the instance list or have the 2008 Management Studio emulate Enterprise Manager from SQL 2000 - where it retains all the SQL servers that you've previously registered and grouped?

    Thanks,

    Tim

    Membrane.Inside("Insane");

  • August 22, 2008 at 11:59 am

    #862063

    Sorry but according to 2008 BOL it states "You cannot import registered server information into SQL Server 2008 from earlier versions of SQL Server."

    Hopefully you don't have a bunch to do.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • August 22, 2008 at 12:03 pm

    #862066

    Thanks David. That's what Microsoft and google say too, but I was hoping for a loophole.

    I could tell you how many I have to do, but a "bunch" is a relative term. 🙂

    Membrane.Inside("Insane");

  • August 27, 2008 at 8:23 am

    #863766

    Just saw this solution on Buck Woody's blog site. Thought it was probably too late for you but not for others. This doesn't exactly fit your problem as you were on 2000 but it should work for 2005 users. I don't remember if you can import from 2000 into 2005 SSMS, its been a while.

    http://blogs.msdn.com/buckwoody/archive/2008/08/18/importing-sql-server-2005-registered-servers-to-sql-server-2008.aspx

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

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

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