msde for web site

hi all!
i cannot figure out the difference between msde and sql server. both do the
same thing...
does msde have sprocs?
does msde have DTS?
re sql server licensing.
what is the difference between enterprise 1 proc lic and starndard 1 proc
lic?
whay should not i always use msde?
i'm sorry if these questions are naive but i have NO idea...
regards
m
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.827 / Virus Database: 564 - Release Date: 03/01/2005
hi m,
"m" <usmirza@.hotmail.com> ha scritto nel messaggio
news:%23JtwxrC9EHA.2452@.TK2MSFTNGP14.phx.gbl
> hi all!
> i cannot figure out the difference between msde and sql server. both
> do the same thing...
> does msde have sprocs?
> does msde have DTS?
>
actually they are the same things... well, they are based on the same core
engine and bits, but are different version of the same DBMS...
please have a look at
http://www.microsoft.com/sql/evaluat...ew/default.asp and
http://www.microsoft.com/sql/evaluat...s/choosing.asp for
differences among the editions
MSDE is only provided with the DTS-runtime, os ti can execute DTS packages
but not design new ones...

> re sql server licensing.
> what is the difference between enterprise 1 proc lic and starndard 1
> proc lic?
http://www.microsoft.com/sql/evaluat...s/choosing.asp

> whay should not i always use msde?
it really depends on your needs, and you probably better have a look at all
the versions comparisons for a better idea of your requirements...
regards
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply