When you install Microsoft SQL Server 2000 Desktop Engine
(Windows) and Microsoft SQL Server 2000 Desktop Engine (also known as MSDE
2000) on your computer, you may not be able to distinguish between the two
instances in the Add or Remove Programs dialog box entry in
Control Panel.
↑ Back to the top
You can use the following methods to distinguish between the
instances of MSDE 2000 and Microsoft SQL Server 2000 Desktop Engine (Windows)
that are installed on the computer.
- Use the SQL Server error log file
To identify whether an instance corresponds to MSDE 2000
or to Microsoft SQL Server 2000 Desktop Engine (Windows), you can use the SQL
Server error log file. To do so, follow these steps
- Open Windows Explorer.
- Locate the following folder:
<Installation Drive>:\Program Files\Microsoft SQL Server\MSSQL$<instance name>\LOG - Use Notepad to open the error log file.
If the specified instance is an instance of MSDE 2000, the
SQL Server error log file contains lines that are similar to the
following:
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)
However, if the specified instance is an instance of
Microsoft SQL Server 2000 Desktop Engine (Windows), the SQL Server error log
file contains lines that are similar to the following:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine (Windows) on Windows NT 5.0 (Build 2195: Service Pack 3)
Note The product name for the instance of Microsoft SQL Server 2000
Desktop Engine (Windows) contains the word "(Windows)" in the product name.
- Use the @@VERSION configuration function
You can also distinguish between the instances of MSDE
and Microsoft SQL Server 2000 Desktop Engine (Windows) by using the @@VERSION
configuration function. You can connect to the instance of MSDE or to the
instance of Microsoft SQL Server 2000 Desktop Engine (Windows) by using Query
Analyzer. In Query Analyzer, run the following query to obtain the version for
the instance:
If the current instance is an instance of MSDE 2000, the result of
the query is similar to the following:
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)
However, if the current instance is an instance of Microsoft
SQL Server 2000 Desktop Engine (Windows), the result of the query is similar to
the following:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine (Windows) on Windows NT 5.0 (Build 2195: Service Pack 3)
Notice that the result of the query is the same as the SQL
Server error log file information.
↑ Back to the top
Microsoft has confirmed that this is a bug in the Microsoft products that are
listed at the beginning of this article.
↑ Back to the top
The problem that is specified in the "Symptoms" section
occurs only when the instance of Microsoft SQL Server 2000 Desktop Engine
(Windows) version 1.0 is installed on the computer because build number
8.00.760 for Microsoft SQL Server 2000 Desktop Engine (Windows) version 1.0 is
the same as the build number for MSDE Service Pack 3. Therefore, you may not be
able to distinguish between an instance of MSDE 2000 and an instance of
Microsoft SQL Server 2000 Desktop Engine (Windows) in the Add or Remove
Programs entries.
↑ Back to the top