Re: Cant see Enterprise Manager with MSDE 2000



Enterprise Manager is not shipped / included in MSDE. YOu will have to
use an additional tool for administering the databases:

http://sqlserver2000.databases.aspfaq.com/how-do-i-manage-sql-server/msde.html

SQl Server 2005 does not have Enterprise Manager at all, the new tool
is called Managment Studio (for Express with the suffix Express) and
can be downloaded separately from :
http://msdn.microsoft.com/vstudio/express/sql/download/ or already
included in the advanced services.

HTH, Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---


pmud schrieb:

Hi
I installed MSDE 2000. I dont see the enterprise manager though? How to I
restore 2 databases which I need to. I know we can do this with enterprise
manager in sql server 2000. How do I restore and see the database with MSDE
2000??

Also, how can I see Enterprise Manager in SQL Express 2005?

Thanks

--
pmud

.



Relevant Pages

  • RE: How to configure WSS to use SQL server instead of MSDE
    ... This is why, in this post, I wanted to focus on only WSS features. ... Apparently WSS DOES NOT SUPPORT SQL Server since it has no tool (that we ... >>MSDE databases for its configuration and content ...
    (microsoft.public.sharepoint.windowsservices)
  • Cannot insert explicit value for identity...
    ... I am developing an integration process between two databases. ... The main database is the SQL Server, the MSDE will contain a really ...
    (comp.databases.ms-sqlserver)
  • Re: MYSQL what should I know
    ... MSDE is Microsoft Desktop Engine (I think that's ... size (but you can have many databases in one instance, and you can have up to 16 ... It supports Views, Stored Procedures, everything that SQL Server does. ... supposedly you can buy Enterprise manager and Query analyzer for $75 or so from ...
    (microsoft.public.vb.general.discussion)
  • Re: Newbie Questions
    ... I have noticed that some of the documentation talkes about SQL Server ... > MSDE is the old database engine there is now as well SQL server Express, ... > hard to find (mostly everything is done with scripting ASP style). ... How do I use the MSDE functionality in relation to databases? ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Change default to named instance??
    ... Take a backup of all databases ... Stop SQL Server and copy the MDF and LDF to a safe place ... Un Install the MSDE ... > conflicts with other app's msdes, I now want to use a named instance. ...
    (microsoft.public.sqlserver.msde)

Loading