BUG: You may not be able to distinguish between instances of Microsoft SQL Server 2000 Desktop Engine or Microsoft SQL Server 2000 Desktop Engine (Windows) in the Add or Remove Programs entry in Control Panel (823465)

WORKAROUND

• 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
  1. Open Windows Explorer.
  2. Locate the following folder:
     <Installation Drive>:\Program Files\Microsoft SQL Server\MSSQL$<instance name>\LOG
  3. 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:

  SELECT @@version

  
  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)