January 29, 2003 at 1:02 pm
How can I tell if MSDE 2000 is installed on my servers
January 29, 2003 at 1:25 pm
Verify whether service "MSSQLServer' is running in the machine.
To determine which version of SQL Server 2000 is running, connect to SQL Server 2000 by using Query Analyzer or OSQL, run the following code:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
January 29, 2003 at 3:21 pm
Also, in the registry (classes_root|Installer) will be the product Ids, under each of these is the product name. You will see SQL Server Desktop Engine listed there.
Steve Jones
January 31, 2003 at 5:27 am
quote:
Should I see MSDE 2000 or Desktop Engine when I run this script. I have some servers that show me Enterprise Edition and others Standard while some developers who have it installed on their machines have Personal Edition.Verify whether service "MSSQLServer' is running in the machine.
To determine which version of SQL Server 2000 is running, connect to SQL Server 2000 by using Query Analyzer or OSQL, run the following code:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply