differentiating between MSDE and other SQL Server editions

[Onkar Walavalkar]

 I want to be able to detect whether a SQL server installation is a pure SQL server installation or an MSDE installation. I want to be able to differentiate
between these 2. I have seen the following observations after running select serverproperty('edition') command and running select @@version command.

 

No	As seen in add/ remove programs	Result of “select @@version”	Result of “select serverproperty(‘edition’)”
1.	Microsoft SQL Server Desktop Engine (version 8.00.760)	Microsoft SQL Server  2000 - 8.00.760 (Intel X86)   Dec 17 2002 14:22:05   Copyright (c) 1988-2003 Microsoft Corporation  Personal Edition on Windows NT 5.1 (Build 2600: Service Pack 1)	Personal edition
2.	Microsoft SQL Server 2000 (version 8.00.761)	Microsoft SQL Server  2000 - 8.00.760 (Intel X86)   Dec 17 2002 14:22:05   Copyright (c) 1988-2003 Microsoft Corporation  Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 1)	Developer Edition
3.	Microsoft SQL Server Desktop Engine (version 8.00.760)	Microsoft SQL Server  2000 - 8.00.760 (Intel X86)   Dec 17 2002 14:22:05   Copyright (c) 1988-2003 Microsoft Corporation  Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 1)	Desktop Engine
4.	Microsoft SQL Server Desktop Engine	Microsoft SQL Server  2000 - 8.00.760 (Intel X86)   Dec 17 2002 14:22:05   Copyright (c) 1988-2003 Microsoft Corporation  Desktop Engine on Windows NT 5.0 (Build 2195: Service Pack 3)	Desktop Engine
5.	Microsoft SQL Server 2000 (version 8.00.894)	Microsoft SQL Server  2000 - 8.00.194 (Intel X86)   Aug  6 2000 00:57:48   Copyright (c) 1988-2000 Microsoft Corporation  Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 3)	Standard Edition
6.	Microsoft SQL Server 2000 (version 8.00.761)	Microsoft SQL Server  2000 - 8.00.760 (Intel X86)   Dec 17 2002 14:22:05   Copyright (c) 1988-2003 Microsoft Corporation  Enterprise Edition on Windows NT 5.2 (Build 3790: )	Enterprise Edition

 

As mentioned in this article http://www.microsoft.com/sql/evaluation/overview/default.asp on Microsoft site, personal edition and desktop engine are 2 different editions in MS SQL 2000. Then the observation made in result 1 of this table, is it a defect? It surely shows me as Microsoft SQL Server Desktop Engine in Add / Remove programs although I have the personal edition installed on my machine.

 

Is it an intended behavior to treat “personal edition” as “desktop engine” and show it that way in Add/ remove programs?

 

Thanks.

 

 

[John Bell]

Hi

I get the correct results!

SET NOCOUNT ON
select '@@version' AS Command
SELECT @@version AS Version
select 'serverproperty(''edition'')' AS Command
SELECT serverproperty('edition') AS Edition
/*

Command
---------
@@version

Version

--------------------------------------------------------------

Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation

Personal Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

Command
-------------------------
serverproperty('edition')

Edition

--------------------------------------------------------------
Personal Edition

*/

John

[Onkar Walavalkar]

I am also getting 'personal edition' after running "select @@version" and
"select serverproperty('edition')" for personal edition installation. The
problem I face is in "Add/ Remove Pragrams". Here I see "Microsoft SQL
Server Desktop Engine" for both MSDE and personal edition. What I am asking
is if that is an expected behavior to treat personal edition as MSDE and
display MSDE (and not Microsft SQL Server 2000) for personal edition.

John, for your personal edition installation, can you please tell me what
you see in "Add/ Remove programs"?

thanks,
onkar

"John Bell" <John...@discussions.microsoft.com> wrote in message
news:EFFC17F2-FF8B-49D8...@microsoft.com...

[John Bell]

Hi

I see "Microsft SQL Server 2000", but I have never had MSDE on this
machine. You may want to remove everything and try a fresh install.

John