July 15, 2005 at 4:11 pm
anyone know how you can tell the edition of SQL Server without it being running?
It's for licensing for a friend and here's what he wrote:
Here is the issue we discussed earlier:
I need to programmatically determine the Edition (Personal, Developer, Standard, Enterprise, and MSDE) of each instance of SQL Server installed on a system.
I can run a script locally on each system in order to retrieve the edition information.
This needs to occur without the MSSQL services running as I may not have rights to access the database or the services may be disabled.
Most options require the services to be running:
T-SQL: SELECT SERVERPROPERTY('Edition')
SELECT @@VERSION
SQLDMO: SQLServer2.VersionString
WMI: MSSQL_SQLServer.VersionString
Steve
July 15, 2005 at 4:20 pm
Registry:
Regular Instance:
Edition: HKLM\Software\Microsoft\MSSQLServer\Setup\Edition
Version: HKLM\Software\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion\CSDVersion
Named Instance:
Edition: HKLM\Software\Microsoft\Microsoft SQL Server\<InstanceName>\Setup\Edition
Version: HKLM\Software\Microsoft\Microsoft SQL Server\<Instance Name>\MSSQLServer\CurrentVersion\CSDVersion
K. Brian Kelley
@kbriankelley
April 24, 2006 at 7:47 am
Brian,
I am trying to find the edition and version through registry and on some of my SQL servers, i couldn't find the Edition Property ( on the both regular and Names). Though some of the server has this key.
Any thoughts ?
Rgds
SK
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply