Re: Need tool (Enterprise manager?) on Vista to access SQL Server 2000

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hello Gary,


Microsoft has a tool that you could manage your instances with which is called "Microsoft SQL Server Management Studio Express" Also there are third party (shareware) tools that you can administer your instances by. You could search from google for them.

Microsoft SQL Server Management Studio Express:
http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

Description (from Microsoft's site)

Brief Description
Microsoft SQL Server Management Studio Express (SSMSE) is a free, easy-to-use graphical management tool for managing SQL Server 2005 Express Edition and SQL Server 2005 Express Edition with Advanced Services.

Overview
Microsoft SQL Server Management Studio Express (SSMSE) is a free, easy-to-use graphical management tool for managing SQL Server 2005 Express Edition and SQL Server 2005 Express Edition with Advanced Services. SSMSE can also manage instances of the SQL Server Database Engine created by any edition of SQL Server 2005.

Note: SSMSE cannot manage SQL Server Analysis Services, Integration Services, Notification Services, Reporting Services, SQL Server Agent, or SQL Server 2005 Mobile Edition.


--
Ekrem Önsoy




"Gary" <Gary@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:E093D216-ED76-4F90-8240-8B0A11FBF394@xxxxxxxxxxxxxxxx
What I'd like to do is download Enterprise Manager or something close, to
access and maniplate a remote SQL Server 2000 database.

I'm familiar with those tools. but for the life of me I can't figure out
what to download. I don't need to install a database on my PC. It seems like
I can't just download the client tools...but maybe I'm wrong?

I tried installing SQL Server 2000, but it says it's incompatible with my
operating system. It sounds like the SQL Server 2005 replacement for
Enterprise Manager only works on 2005 databases...why is this so hard?

Any help appreciated.

Gary

.

Relevant Pages