How can I get access to SQL 2000 database like SQL Server Management Studio

The company that I work for acquired a competitor. They brought over some of their equipment and one piece is a server running SQL server 2000. We have SQL 2005 already in our system and I am somewhat familiar with it, but not an expert by any means. I am trying to get into the data on the SQL 2000 machine but cannot find any interface to do so. I have done some searching and found that there is not a Management Studio for 2000, but there is supposed to be "Enterprise Manager". But I cannot find that application anywhere on the machine.


Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

You can install and use the 2005 SQL Management Studio on that machine and it should work fine with sql 2000.
Anthony PerkinsCommented:
Actually I would not install SSMS ong that machine as that would require you to have another license for it.  Instead I would simply add (register) that SQL Server 2000 box on your workstation's SSMS app.  You can do most of what you need on a SQL Server 2000 box using SSMS 2005

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
If that server is on your nertwork (that I assumed was not) then "acperkins" solution will work. If it is not on the network and there is a license issue, you can use 2005/2008 Server Management Studio Express which is free and downloadable from MS.  
Anthony PerkinsCommented:
>>there is supposed to be "Enterprise Manager". But I cannot find that application anywhere on the machine.<<
And that may be because they have the free edition of SQL Server 2000: MSDE or SQL Server Desktop. This edition did not include Enterprise Manager
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.