How can I determine the version of SQL 2005 Server on a machine.
I need to know if it is a Server license or a Processor license.
select serverproperty('LicenseType'), serverproperty('NumLicenses')
Also found this:
But is altering the registry the only way?