Re: MSDE Limitations

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: news.microsoft.com (jim_at_cabill.com)
Date: 10/09/04

  • Next message: Alan Brewer [MSFT]: "Re: MSDE Limitations" 
    Date: Fri, 8 Oct 2004 20:25:47 -0400

    Thanks for the information, Anikan.

    Jim Evans

    "Anikan" <anonymous@discussions.microsoft.com> wrote in message
    news:1a8d01c4ad7f$17d25a50$a301280a@phx.gbl...
    >
    > >-----Original Message-----
    > >What are the limitations of MSDE compared to SQL 2000?
    > >
    > >tia,
    > >
    > >Jim Evans
    >
    > It's a scaled down version of sql 2000 but it doesn't
    > mean its not as powerfull. It is scaled down to allow for
    > it's easy redistribution. Clients might not need a full
    > fledged SQL server and it may not seem feasible to
    > purchase SQL Server for a small application but they
    > might still need one?? MSDE is limited to only 5
    > concurrent database connections and is subject to various
    > performance goveners. MSDE also has NO gui for
    > administration such as SQL Enterprise Manager but it does
    > come with various admin programs to accomplish those
    > tasks (just not as pretty). Hope that helps.
    >
    >

  • Next message: Alan Brewer [MSFT]: "Re: MSDE Limitations"

    Relevant Pages

    • Re: What version of SQL is on SBS R2 Standard and can I use it?
      ... I followed your instructions and successfully installed SQL Express, ... During the application install the applicaton didn't reconize the default ... SQLEXPRESS and two MSDE instances. ... super administrative purposed within SQL Server and is not the same as the ...
      (microsoft.public.windows.server.sbs)
    • Re: What version of SQL is on SBS R2 Standard and can I use it?
      ... named instance but default for SQL Express). ... A user level account works ... super administrative purposed within SQL Server and is not the same as the ... you can have MSDE and 2005 Express ...
      (microsoft.public.windows.server.sbs)
    • Re: Renaming Computer Running SQL or MSDE
      ... I've only seen problems with SQL Server 7 (ie and MSDE v1). ... >> In my experience when you rename a computer ...
      (microsoft.public.sqlserver.msde)
    • Re: SQL or Access DB
      ... But with SQL Express ... is it worth it any longer to mess with an MSDE installation? ... > correctly write an installer project that installed MSDE correctly and set ... It comes with SQL Server 2000 Standard. ...
      (microsoft.public.dotnet.languages.vb)
    • Re: Processor Based License Model
      ... You can redistribute MSDE with your application (for ... >> If performance becomes a problem, you just buy a SQL Server license. ... > database while being able to yank out MSDE and put full-blown SQL ...
      (comp.os.vms)