Re: WSS & WMSDE

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks. That seems to nicely confirm the no limit to database size thing.

Actually the start of the final paragraph you quote is wrong. Some Microsoft
routines other than WSS can access WMSDE / use WMSDE to store data - I think
the term used when describing this is something like components: at any rate
it's where Microsoft have allowed it.

Now if anyone can supply a link for that ....

Mike Walsh, Helsinki, Finland

"chaserNL" <paul.paschedag@xxxxxxxxxxxxxx> wrote in message
news:1118387218.620101.163630@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> http://blogs.msdn.com/grahamtyler/archive/2004/10.aspx
>
> "Windows SharePoint Services (WSS) is a Windows Server 2003 component,
> and if SPS 2003 is not installed WSS uses a special version of MSDE,
> known as SQL Server 2000 Desktop Engine (Windows), or WMSDE. This is an
> unthrottled version of MSDE designed only to be used by Windows
> components, and as such is not limited in the same way as MSDE. The
> maximum size limit and current connections limit have both been
> removed. However it is still much more limited than SQL Server 2000 in
> the following ways:
>
> WMSDE does not include enterprise management tools such as those
> provided with SQL Server 2000 (e.g. SQL Enterprise Manager MMC tool)
> for backing up and restoring the database. However command line tools
> can still be used (e.g. stsadm tool).
>
> WMSDE can only be managed locally - you cannot remotely connect
>
> WMSDE does not support full-text search - so search from within team
> sites is not possible
>
> You cannot deploy WMSDE in web farm/clustered configurations, so the
> solution cannot scale beyond certain limits, and remains a single point
> of failure.
>
> You cannot use WMSDE for anything other than WSS due to the custom
> schema it uses (MSDE or SQL Server 2000 can also be used for other
> custom applications). There is no user interface to edit the database
> file."
>


.

Relevant Pages

  • RE: MSDE, Access, SharePoint... I am not sure where to ask this qu
    ... 1.>> What is the difference between MSDE and WMSDE? ... MSDE that is targeted for use by Windows components only. ... isn't SQL Server Express replacing MSDE and WMSDE? ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • Re: Put database on Internet
    ... > Once you will be able to connect to MSDE or to SQL-Server, ... > and ADP in the same time as frontends to your database. ... >> will be able to serve as SQL server. ...
    (microsoft.public.access.dataaccess.pages)
  • Re: msde2000
    ... Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) is the free, ... As for it being better than MS-Access, the answer to that is probable yes, ... MOST other database DO NOT. ...
    (microsoft.public.vc.mfc)
  • Re: Database Connectivity
    ... But, MSDE has been know to work very reliably in small user LANS, ... > just a simple step to attach the tables from MSDE to SQL Server. ... database, or pay for an "industrial-strength" version of it when there ... Don't like Microsoft?, sounds like a personal problem to me. ...
    (comp.lang.python)
  • Re: Help with cost and additional software
    ... WMSDE is MSDE 2.0 with most of the restrictions removed (2GB size limit; ... Would SQL Server 2005 Express work for that? ... You still need to pay licenses for the Operating System. ... You can use the built-in WMSDE for the database for nothing. ...
    (microsoft.public.sharepoint.windowsservices)