Re: Microsoft SQL Desktop Engine - using

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I'm not sure exactly what the limitations of MSDE are, but I have some
co-workers that have pushed it pretty hard and was told the limitations
weren't quite as bad as MS tries to make them out to be. I don't have any
first-hand experience so I can't say for sure, but I think you might want to
test first.

That said, you want to stay within the licensing and that's probably where
the limitations are more than in the code since MSDE really is just MS Sql
Server without the client-side tools.

Pete

"Nicholas Paldino [.NET/C# MVP]" <mvp@xxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:uddSKgFPFHA.3372@xxxxxxxxxxxxxxxxxxxxxxx
> Actually, you should be using SQL Server Express (a new product
> offering). It is free, but has some limitations (1 GB RAM, 1 processor,
4GB
> db size). You can find it at:
>
> http://lab.msdn.microsoft.com/express/sql/
>
> Also, there is a link to a features page which you can see the
> limitations, but it should suit your needs.
>
>
> --
> - Nicholas Paldino [.NET/C# MVP]
> - mvp@xxxxxxxxxxxxxxxxxxxxxxxxxxx
> "1qa2ws" <1qa2ws@xxxxxxxxx> wrote in message
> news:d36b2b$3f6$1@xxxxxxxxxxxxxxxxxx
> > "Nicholas Paldino [.NET/C# MVP]" <mvp@xxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote
> > in message news:%23rqFoZFPFHA.244@xxxxxxxxxxxxxxxxxxxxxxx
> >> Yes, you should be able to use MSDE 2000. However, depending on the
> >> needs of your application, you might not be able to use it (I think
there
> >> are limitations on connections, processors, and some other ones, you
have
> >> to check) depending on how much your application needs to do.
> >>
> >> Hope this helps.
> >
> >
> > 1) Where can I find MSDE limitations?
> > 2) Can I distribute MSDE having Standard License? The buyer of my
> > application doesn't have the SQL server, so he needs something, so I
want
> > to install him the MSDE. Can he use it?
> >
> > 1qa2ws
> >
> >
>
>


.

Relevant Pages

  • Re: Microsoft SQL Desktop Engine - using
    ... It is free, but has some limitations (1 GB RAM, 1 processor, ... you should be able to use MSDE 2000. ... >> application doesn't have the SQL server, so he needs something, so I want ... >> to install him the MSDE. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: SQL Server 2000 developer edition
    ... > utilities from my company's SQL Server CD. ... but keep in your mind, that MSDE has got some limitations: ...
    (microsoft.public.fox.programmer.exchange)
  • Re: NDataStore Information
    ... >> But MSDE has limitations. ... > I gave up on it because of the lack of documentation. ... > admin tools - you have to buy Access or SQL Server to be productive ... and using the MSDE may have limitations that affect him ...
    (borland.public.delphi.non-technical)
  • Re: MSAccess DB as a linked server - The provider ran out of memor
    ... Well, I guess my point was in directing you to that page is, you can't ... Server that does not have these limitations. ... and the data Bulk uploaded into the remote MSDE database. ...
    (microsoft.public.sqlserver.msde)
  • MSDE
    ... I would like to know how many users (computers) can be connected to the ... desktop version of SQL Server (MSDE). ... Which are the limitations to use it. ...
    (borland.public.delphi.database.ado)