MSDE in Personal , Entireprise Sql

  • MSDE is a scaled back version of SQL server that is Free. Do not confuse it with Enterprise Edition or Personal Edition.

    If you are just installing MSDE - the edition makes no difference because there is only MSDE not MSDE Personal nor MSDE Enterprise.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Thank you for your replay ,

    Your answer explained everything to me ,

    So I assume that After I Install the SQL 2000 Enterprise it will update MSDE that came with it , or may be it's has another MSDE embedded with it to install !

    have a good day

  • You're welcome

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Once you install MSDE, there is no upgrading it to another version like Standard, Enterprise, etc. You can install Enterprise as another instance of SQL on the same machine, but it will be totally separate, with its own set of databases, install files, services, etc.

    Joie Andrew
    "Since 1982"

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply