SQL Server 2000 vs. MSDE

[Diana Finley]

Hi all,

I just got SQL Server 2000, but I already have MSDE installed. Is there any
reason I would want to keep MSDE around on my computer if I install SQL
Server 2000? I use MS Visual Studio 2002 on Windows XP SP2, in case it
makes any difference. I intend to deinstall MSDE before installing SQL
Server 2000, but I get the impression from a few posts that some people have
both installed and I'm not sure why that would be done. What functionality
is in MSDE that is not in SQL Server 2000?

Thanks for answering.

--Diana

[John Bell]

Hi

MSDE is the desktop edition of SQL Server, the main difference is that you
don't get the client tools. If you are wanting to install the Developer
Edition you will get similar functionality to the Enterprise Edition,
therefore if your target database is not MSDE I don't really see the point
of keeping it either.

If you want to look at the features available check out:
http://www.microsoft.com/sql/evaluat...s/choosing.asp
http://www.microsoft.com/sql/msde/howtobuy/default.asp
http://www.microsoft.com/sql/spotlig...dsqlserver.asp

John
"Diana Finley" <di*********@nospam.yahoo.com> wrote in message
news:vD*******************@newssvr33.news.prodigy. com...

Hi all,

I just got SQL Server 2000, but I already have MSDE installed. Is there
any reason I would want to keep MSDE around on my computer if I install
SQL Server 2000? I use MS Visual Studio 2002 on Windows XP SP2, in case
it makes any difference. I intend to deinstall MSDE before installing SQL
Server 2000, but I get the impression from a few posts that some people
have both installed and I'm not sure why that would be done. What
functionality is in MSDE that is not in SQL Server 2000?

Thanks for answering.

--Diana