And for the most part, it looks like MSDE and Personal Edition are the same
except the Desktop Edition comes with the Tools (EM, QA, Profiler).  Desktop
Engine is just the database.

So I don't stand corrected  :-)



-----Original Message-----
From: Costas Piliotis 
Sent: Tuesday, October 30, 2001 12:56 PM
To: CF-Talk
Subject: RE: SQL Server 2000 desktop version.


Ahhh...  Ooops...  I stand corrected.  There's a first for everything =)

Here's Microsoft's link to a comparison:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_
ar_sa2_9gz4.asp

-----Original Message-----
From: Dave Watts [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, October 30, 2001 11:01 AM
To: CF-Talk
Subject: RE: SQL Server 2000 desktop version.


> It's called msde.  It comes with Office 2000/XP.  Not Really a desktop 
> edition but rather a scaled down implementation of SQL Server.
> 
> As far as I know, if you have an Office 2000/XP licence, you have a 
> MSDE licence as well.

MSDE isn't the same as SQL Server Desktop Edition. With SQL Server, you
could install the Desktop Edition on a Windows 98 machine, for example, and
you'd get the core SQL Server engine (with some pretty severe size and
functionality limitations) and the Enterprise Manager tools. MSDE, on the
other hand, is simply the SQL Server engine (with its own, different, set of
limitations), with no Enterprise Manager tools.

If you develop applications with Visual Studio, you can redistribute MSDE
with those applications, as an alternative to using Access. You can't
redistribute SQL Server Desktop Edition.

> Do you need a license to install the desktop version of SQL Server 
> 2000?

As for needing a license to install SQL Server Desktop Edition, I'm sure you
need one, but I don't know how much it is. You'd also need licenses for
connections, I suspect, if you were to actually have any connections to it.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to