Difference between revisions of "Microsoft SQL Server License"

From wikieduonline
Jump to navigation Jump to search
Tags: Mobile web edit, Mobile edit
 
(2 intermediate revisions by the same user not shown)
Line 12: Line 12:
  
 
  SELECT * FROM sys.dm_db_persisted_sku_features;<ref>https://www.sqlshack.com/sql-server-edition-upgrade/</ref>
 
  SELECT * FROM sys.dm_db_persisted_sku_features;<ref>https://www.sqlshack.com/sql-server-edition-upgrade/</ref>
 +
 +
 +
<pre>
 +
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
 +
</pre>
  
  
 
== See also ==
 
== See also ==
 
* {{SQL Server}}
 
* {{SQL Server}}
 +
* {{Windows}}
 +
 +
[[Category:Licenses]]
 +
[[Category:Databases]]

Latest revision as of 06:21, 30 November 2020

This article is a Draft. Help us to complete it.





[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[edit]

  • ↑ https://www.sqlshack.com/sql-server-edition-upgrade/
    • Retrieved from "https://www.wikieduonline.com/index.php?title=Microsoft_SQL_Server_License&oldid=44381"

    Advertising: