(imported topic written by jpeppers91)
I’m trying to determine the SQL Editions whether it is Standard, Enterprise and etc. This is the revelance I’ve come with so far but apparently I’m missing something else because it is not reporting all the SQL servers edition type.
if (exists Key “HKLM\software\Microsoft\MSSQLSERVER\Setup” of registry) and exists value “Edition” of key “HKLM\software\Microsoft\MSSQLSERVER\Setup” of registry then value “Edition” of key “HKLM\software\Microsoft\MSSQLSERVER\Setup” of registry as string else if (exists Key “HKLM\software\Microsoft\Microsoft SQL Server\90\Tools\Setup” of registry) and exists value “Edition” of key “HKLM\software\Microsoft\Microsoft SQL Server\90\Tools\Setup” of registry then value “Edition” of key “HKLM\software\Microsoft\Microsoft SQL Server\90\Tools\Setup” of registry as string else “N/A”