Difference between revisions of "Microsoft SQL Server License"

From wikieduonline
Jump to navigation Jump to search
Tags: Mobile web edit, Mobile edit
Tags: Mobile web edit, Mobile edit
Line 6: Line 6:
  
  
<pre>
+
 
ECLARE @Version NVARCHAR(128)  
+
[[ECLARE]] @Version NVARCHAR(128)  
SET @Version =  
+
SET @Version =  
    CONVERT(NVARCHAR(128),SERVERPROPERTY ('ProductVersion'))
+
    CONVERT(NVARCHAR(128),SERVERPROPERTY ('ProductVersion'))
SELECT
+
SELECT
  CASE
+
  CASE
    WHEN @Version like '11%'  THEN 'SQL SERVER 2012'
+
      WHEN @Version like '11%'  THEN 'SQL SERVER 2012'
    WHEN @Version like '12%'  THEN 'SQL SERVER 2014'
+
      WHEN @Version like '12%'  THEN 'SQL SERVER 2014'
    WHEN @Version like '13%'  THEN 'SQL SERVER 2016'     
+
      WHEN @Version like '13%'  THEN 'SQL SERVER 2016'     
    ELSE 'Unknown'
+
      ELSE 'Unknown'
  END AS 'Sql Server Version Name',
+
  END AS 'Sql Server Version Name',
  SERVERPROPERTY('ProductVersion') AS ProductVersion,
+
  SERVERPROPERTY('ProductVersion') AS ProductVersion,
  SERVERPROPERTY('Edition') AS Edition,
+
  SERVERPROPERTY('Edition') AS Edition,
  SERVERPROPERTY('ProductLevel') AS ProductLevel
+
  SERVERPROPERTY('ProductLevel') AS ProductLevel
</pre>
 
  
  

Revision as of 14:12, 28 April 2025

[Error Message] The SQL Server product key is not valid. To proceed, re-enter the product key values from the Certificate of Authenticity (COA) or SQL Server packaging. [Details] Microsoft.SqlServer.Configuration.SetupExtension.InvalidPidException: The SQL Server product key is not valid. To proceed, re-enter the product key values from the Certificate of Authenticity (COA) or SQL Server packaging.


SELECT * FROM sys.dm_db_persisted_sku_features;[1]


ECLARE @Version NVARCHAR(128) 
SET @Version = 
    CONVERT(NVARCHAR(128),SERVERPROPERTY ('ProductVersion'))
SELECT
  CASE
     WHEN @Version like '11%'   THEN 'SQL SERVER 2012'
     WHEN @Version like '12%'   THEN 'SQL SERVER 2014'
     WHEN @Version like '13%'   THEN 'SQL SERVER 2016'    
     ELSE 'Unknown'
  END AS 'Sql Server Version Name',
  SERVERPROPERTY('ProductVersion') AS ProductVersion,
  SERVERPROPERTY('Edition') AS Edition,
  SERVERPROPERTY('ProductLevel') AS ProductLevel


See also

  • https://www.sqlshack.com/sql-server-edition-upgrade/
  • Advertising: