sql server msde: Difference between MSDE 7 and SQL 7 -- sql server msde

You're in the

sql server msde

group:

Difference between MSDE 7 and SQL 7

Monik
2/1/2007 12:14:02 PM

sql server msde: Is there a registry key that will tell me if am running MSDE 7 or MS
SQL 7?

Thanks

Re: Difference between MSDE 7 and SQL 7

Jens
2/1/2007 12:48:49 PM

I guess MSDE 7 is just a typo of yours, but there does not have to be
only the one OR the other, there can also be the two of them installed
on the server, so it would be evenbetter for you to enumerate the
instances on the machine using DMO or SMO.

HTH, Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---

Re: Difference between MSDE 7 and SQL 7

Monik
2/1/2007 1:42:45 PM

This is the situation, I have a wise installation that needs to check
if the target pc is running either MSDE or full SQL. In our case the
target pc will only be running one or the other. Thats why I was
wondering if there is a registry key that will tell me which one is
running.

Re: Difference between MSDE 7 and SQL 7

Alan Brewer [MSFT]
2/1/2007 1:53:09 PM

Mapping MSDE versions to their corresponding versions of SQL Server:

MSDE 1.0 used SQL Server 7.0 technology.
MSDE 2000 (also known as SQL Server 2000 Desktop Engine) used SQL Server
2000 technology.
SQL Server 2005 Express Edition is the MSDE replacement for SQL Server 2005.

You could only run one instance of either MSDE 1.0 or SQL Server 7.0 on a
computer, support for multiple instances of the Database Engine on one
computer was not introduced until SQL Server 2000.

I don't know of a registry key, but if you issue a SELECT @@VERSION
statement it will report the version of SQL Server 7.0 (MSDE or an edition
such as Standard or Enterprise).

--
Alan Brewer [MSFT]
SQL Server Documentation Team

Download the latest Books Online update:
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

This posting is provided "AS IS" with no warranties, and confers no rights.

Re: Difference between MSDE 7 and SQL 7

William (Bill) Vaughn
2/3/2007 8:39:55 AM

Alan is right, but there are also .NET Framework factory classes that can
report all instances (2000 or 2005) on a network and on any specific
instance, the version etc. There is an example of this on my book's DVD.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server msde group.

home · blog · groups

Questions? Comments? Contact the dn