Re: Use Management Studio with 2000 databases?

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



"jmelkerson" <jmelkerson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0C7709B4-0BB5-4228-ACAC-C39793D613C4@xxxxxxxxxxxxxxxx
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?


.

Relevant Pages

  • Re: How can I remove Public access to SQL Express dbs?
    ... Will the SQL Server Management Studio work ... You can't delete guest but can render it unusable by revoking ... CONNECT permission in databases other than master and tempdb. ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server Management Studio Cannot Open SQL Express Files
    ... Currently I can work with the DB in SSMS but not in VS. ... I suggest you to open SQL Server Configuration Manager and see how many SQL ... If I create the database in VS2005 using the ... If I create the DB in Management Studio I cannot work with it in VS2005. ...
    (microsoft.public.sqlserver.tools)
  • Re: qiestion about master
    ... Login into SQL Express using SQLCMD or SQL Server Express management studio ... databasesystem are linked or not to the master, ... Are those local system databases needed for running the central ...
    (microsoft.public.sqlserver.setup)
  • Re: My SQL Management Studio Has Disappeared?
    ... Why don't you just uninstall the evaluation edition instance and after that install SQL Server Management Studio Express? ... If your databases are attached to the Express Edition, then you'll be able to reach them using SSMSE and connecting to this instance. ...
    (microsoft.public.sqlserver.setup)
  • Re: Where is SQL Management Studio?
    ... Run setup from your sql server dvd and select database engine, ... installation features selected) and can't figure out how I am supposed to ... None of these puts up an UI that I can use to develop databases! ... Management Studio, but I don't ...
    (microsoft.public.sqlserver.setup)