differentiating between MSDE and other SQL Server editions

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 differenti
ate
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 C
opyright (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 C
opyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows N
T 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 C
opyright (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 C
opyright (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 C
opyright (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 C
opyright (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/evalua...
ult.asp on Microsoft site, personal edition and desktop engine are 2 differe
nt editions in MS SQL 2000. Then the observation made in result 1 of this ta
ble, is it a defect? It surely shows me as Microsoft SQL Server Desktop Engi
ne in Add / Remove programs although I have the personal edition installed o
n my machine.
Is it an intended behavior to treat "personal edition" as "desktop engine" a
nd show it that way in Add/ remove programs?
Thanks.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" wrote:

> I want to be able to detect whether a SQL server installation is a pure S
QL server installation or an MSDE installation. I want to be able to differe
ntiate
> between these 2. I have seen the following observations after running sele
ct 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 Win
dows 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 Wi
ndows 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 Windo
ws 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 Windo
ws 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 Win
dows 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 W
indows NT 5.2 (Build 3790: )
> Enterprise Edition
>
>
> As mentioned in this article http://www.microsoft.com/sql/evalua...ult.as
p 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[/c
olor]
? It surely shows me as Microsoft SQL Server Desktop Engine in Add / Remove programs althou
gh 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.
>
>
>|||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" <JohnBell@.discussions.microsoft.com> wrote in message
news:EFFC17F2-FF8B-49D8-9E47-BD77D2E50AF8@.microsoft.com...
> 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" wrote:
>
SQL server installation or an MSDE installation. I want to be able to
differentiate
select serverproperty('edition') command and running select @.@.version
command.
14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Personal Edition
on Windows NT 5.1 (Build 2600: Service Pack 1)
14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Developer Edition
on Windows NT 5.1 (Build 2600: Service Pack 1)
14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on
Windows NT 5.1 (Build 2600: Service Pack 1)
14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on
Windows NT 5.0 (Build 2195: Service Pack 3)
00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Standard Edition
on Windows NT 5.0 (Build 2195: Service Pack 3)
14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition
on Windows NT 5.2 (Build 3790: )
http://www.microsoft.com/sql/evalua...iew/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.
engine" and show it that way in Add/ remove programs?|||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