How do I find out what License has been applied to my SQL Server installation?
This shows the license type and number of licenses:
The following example uses the function SERVERPROPERTY in a SELECT Statement to return information about the server. This situation is helpful when there are multiple instances of SQL Server installed on a Win server. The customer must open another connection to the same instance used for the current connection.
|
1 2 3 |
SELECT SERVERPROPERTY('productversion') as productversion, SERVERPROPERTY ('productlevel') as productlevel, SERVERPROPERTY ('edition') as productlevel |
or
|
1 |
SELECT SERVERPROPERTY('LicenseType'), SERVERPROPERTY('NumLicenses') |
Or more detail:
SERVERPROPERTY is a fascinating system function. It returns many of the system values. I use it very frequently to get different server values like Server Collation, Server Name.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 |
SELECT 'BuildClrVersion' ColumnName, SERVERPROPERTY('BuildClrVersion') ColumnValue UNION ALL SELECT 'Collation', SERVERPROPERTY('Collation') UNION ALL SELECT 'CollationID', SERVERPROPERTY('CollationID') UNION ALL SELECT 'ComparisonStyle', SERVERPROPERTY('ComparisonStyle') UNION ALL SELECT 'ComputerNamePhysicalNetBIOS', SERVERPROPERTY('ComputerNamePhysicalNetBIOS') UNION ALL SELECT 'Edition', SERVERPROPERTY('Edition') UNION ALL SELECT 'EditionID', SERVERPROPERTY('EditionID') UNION ALL SELECT 'EngineEdition', SERVERPROPERTY('EngineEdition') UNION ALL SELECT 'InstanceName', SERVERPROPERTY('InstanceName') UNION ALL SELECT 'IsClustered', SERVERPROPERTY('IsClustered') UNION ALL SELECT 'IsFullTextInstalled', SERVERPROPERTY('IsFullTextInstalled') UNION ALL SELECT 'IsIntegratedSecurityOnly', SERVERPROPERTY('IsIntegratedSecurityOnly') UNION ALL SELECT 'IsSingleUser', SERVERPROPERTY('IsSingleUser') UNION ALL SELECT 'LCID', SERVERPROPERTY('LCID') UNION ALL SELECT 'LicenseType', SERVERPROPERTY('LicenseType') UNION ALL SELECT 'MachineName', SERVERPROPERTY('MachineName') UNION ALL SELECT 'NumLicenses', SERVERPROPERTY('NumLicenses') UNION ALL SELECT 'ProcessID', SERVERPROPERTY('ProcessID') UNION ALL SELECT 'ProductVersion', SERVERPROPERTY('ProductVersion') UNION ALL SELECT 'ProductLevel', SERVERPROPERTY('ProductLevel') UNION ALL SELECT 'ResourceLastUpdateDateTime', SERVERPROPERTY('ResourceLastUpdateDateTime') UNION ALL SELECT 'ResourceVersion', SERVERPROPERTY('ResourceVersion') UNION ALL SELECT 'ServerName', SERVERPROPERTY('ServerName') UNION ALL SELECT 'SqlCharSet', SERVERPROPERTY('SqlCharSet') UNION ALL SELECT 'SqlCharSetName', SERVERPROPERTY('SqlCharSetName') UNION ALL SELECT 'SqlSortOrder', SERVERPROPERTY('SqlSortOrder') UNION ALL SELECT 'SqlSortOrderName', SERVERPROPERTY('SqlSortOrderName') |
