SELECT
SERVERPROPERTY('LicenseType'))
AS LicenseType, CONVERT(char(100),
SERVERPROPERTY('NumLicenses'))
AS NumLicenses, CONVERT(char(100)
When I run this query on SQL Server 2000 boxes with SP3 and SP4 installed I get almost all disabled for the result set. I know that on SS 2005 I will get DISABLED, but what can I do to make this return a result on SS 2000 SP3 and SP4 servers? I know what the licensing is because I can go out to the servers and find out, but the license isn't being returned.