Post reply

Question about SQL Server Management Studio...

  • June 5, 2006 at 10:13 pm

    #172885

    Is it possible to install the SQL Sever management studio as a management tool to manage a SQL 2000 instance without updating the database engine to SQL 05 or install a new named instance in a local server? Does anyone how to do this?

    Thanks!

  • June 6, 2006 at 12:14 am

    #641865

    Yes.

    Install 2005 and when you get to the screen to select what you want installed, just install the workstation components. Unselect the database engine and all the other stuff.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • June 8, 2006 at 9:51 am

    #642579

    No problem.  I'm currently managing 12 SQL 2000 instances using Managemnt Studio on my laptop.  If you have SQL tools installed on your PC, simply uninstall and install the SQL 2005 tools.  Takes a little getting used to the new layout, but after awhile you'll be hooked.

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

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