I just installed SQL Server 2005 Development Edition and I really like
Management Studio as compared to Enterprise Manager.  Is there any reason why
I should NOT use Management Studio to work with my existing SQL Server 2000
databases?

None that I have found.

Show quoteHide quote

One minor issue: you might need to download the Microsoft SQL Server 2000
DTS Designer Components

http://www.microsoft.com/downloads/details.aspx?familyid=DF0BA5AA-B4BD-4705-AA0A-B477BA72A9CB&displaylang=en

Other than that, I have been connecting to SQL Server 2000 databases via SQL
Server Management Studio without any issue.

Show quoteHide quote

On Fri, 21 Jul 2006 10:59:02 -0700, jmelkerson
<jmelker***@discussions.microsoft.com> wrote:

During the CTPs there were issues when installing SQL Server 2000
Enterprise Manager on a machine with SQL Server Management Studio (or
vice versa) - parts of Enterprise Manager wouldn't work. From your
description that is hopefully a potential problem you won't encounter.

Andrew Watt MVP

I would like to point out that you should probably install the SQL Server
Management Studio (SSMS) along side Enterprise Manager (EM) if you use the
following features.
- Database Diagrams. In SSMS, you can only design against SQL 2005 server
databases. You'll need EM for working with SQL 2000 server databases.
- Maintenance plans. You have greater control over the scheduling of Maint
Plans with SQL 2000 than with SSMS going against SQL 2000. Service Pack 2
will address many of these concerns.
Just about everything else works as expected using SSMS against SQL 2000.
There are lots of minor things that SSMS took away - many will be fixed in
SP2 as well.

Thank you,
Bill Ramos, Lead PM, SQL Server Manageability
This posting is provided "AS IS" with no warranties, and confers no rights



Show quoteHide quote

Requirement to use Management Studio for local instances
Stored Procedures in Integration Services
Cannot filter members in Management Studio Browsing a Cube
Sql 2005 can't update maintenance plans?
backup remote database to local hard drive or local database?