SQLServer: Difference between revisions

SELECT SERVERPROPERTY('productversion') AS ProductVersion,
       SERVERPROPERTY('productlevel') AS ProductLevel,
       SERVERPROPERTY('edition') AS Edition;
SELECT SERVERPROPERTY('LicenseType') AS LicenseType,
       SERVERPROPERTY('NumLicenses') AS LicenseNumber;
EXEC sp_readerrorlog @p1 = 0
                    ,@p2 = 1
                    ,@p3 = N'licensing'

SQL Server Upgrade

get current version of SQL server:

SELECT @@VERSION;

Can use the following spreadsheet to work out what build the SQL server is on and what it can be upgraded to:

SQLServerBuilds

There are GDR builds, RTM builds and CU updates. You can upgrade the GDR builds with security updates and go from one GDR build to the next OR do CU updates that contain all the changes. Once you use a CU update from a GDR build you cant go back to GDR. GDR+RTM builds contain all security and updates.

See the following articles on upgrading SQL server:

Upgrade SQL Server

Start planning SQL server upgrade by running the Data Migration Assistant: Data Migration Assistant Download Page

@@ Line 38: / Line 38: @@
                      ,@p3 = N'licensing'
 </syntaxhighlight>
+== SQL Server Upgrade ==
+get current version of SQL server: <syntaxhighlight lang="t-sql">
+SELECT @@VERSION;
+</syntaxhighlight>Can use the following spreadsheet to work out what build the SQL server is on and what it can be upgraded to:
+[https://view.officeapps.live.com/op/view.aspx?src=https%3A%2F%2Fdownload.microsoft.com%2Fdownload%2Fd%2F3%2Fe%2Fd3e28f3d-6a4f-47ce-aaa5-9d74c5590ed6%2FSQLServerBuilds.xlsx&wdOrigin=BROWSELINK SQLServerBuilds]
+There are GDR builds, RTM builds and CU updates. You can upgrade the GDR builds with security updates and go from one GDR build to the next OR do CU updates that contain all the changes. Once you use a CU update from a GDR build you cant go back to GDR. GDR+RTM builds contain all security and updates.
+See the following articles on upgrading SQL server:
+[https://learn.microsoft.com/en-us/sql/database-engine/install-windows/upgrade-sql-server?view=sql-server-ver16 Upgrade SQL Server]
+Start planning SQL server upgrade by running the Data Migration Assistant: [https://www.microsoft.com/en-us/download/details.aspx?id=53595 Data Migration Assistant Download Page]