469,929 Members | 1,817 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,929 developers. It's quick & easy.

SQL Server 2000 vs. MSDE

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
Jul 23 '05 #1
1 1355
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

Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by Edward Mitchell | last post: by
9 posts views Thread by Piedro | last post: by
14 posts views Thread by Developer | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.