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.
I've found
select serverproperty('LicenseType'), serverproperty('NumLicenses')
which returns:
DISABLED NULL
Also found this:
http://blogs.msdn.com/sqlblog/archive/2006/11/10/tracking-license-information-in-sql-2005.aspx
But is altering the registry the only way?