By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,313 Members | 1,145 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,313 IT Pros & Developers. It's quick & easy.

SQL Server 2000 vs. MSDE

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.