How to know what licensing was selected | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to know what licensing was selected

I am trying to know what someone selected for licensing SQL server 2000. I don’t know if they selected per processor or not. Is there anyway to tell? I have not been able to find specifics on what was selected on the MS site or by searching for license here in the General forum. Thank you.

SELECT
SERVERPROPERTY(‘InstanceName’) AS InstanceName,
SERVERPROPERTY(‘Edition’) AS Edition,
SERVERPROPERTY(‘LicenseType’) AS LicenseType,
SERVERPROPERTY(‘NumLicenses’) AS NumLicenses,
SERVERPROPERTY(‘ProductVersion’) AS ProductVersion,
SERVERPROPERTY(‘ProductLevel’) AS ProductLevel MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

and this will show you the version Select @@Version as Version
Madhivanan Failing to plan is Planning to fail
Through EM, right click on any sql server registered to check its properties field. the general tab shows all the general information.

Thank you so much! Now to know what it means when the LicenseType is DISABLED and the NumLicenses is NULL. *edited spelling
Ok, found the info here. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sa-ses_3mi1.asp I am taking this to mean I do not have properly licensed SQL server for my web application that is going to have 30,000 some users. *sighs as he gets last minute assignments to clean up other’s messes*
What edition did you have listed? MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
Instancename = NULL
Edition = Desktop Engine
LicenseType = DISABLED
NumLicenses = NULL
ProductVersion = 8.00.818
ProductLevel = SP3
MSDE is free. There is no need to buy licenses. You are probably not going to be able to support 30,000 some users on that. I might be wrong though. <img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ /><br /><br />MeanOldDBA<br />[email protected]<br /><br />When life gives you a lemon, fire the DBA.
]]>