Microsoft SQL Server Version List

 

Quick summary:

ReleaseRTM (no SP)Latest CU
↓ SQL Server 2019
SQL Server latest version
SQL Server 15
codename Aris Seattle
Support end date: 
Ext. end date: 
15.0.2000.5CU6 (15.0.4053.23, August 2020)
↓ SQL Server 2017
SQL Server 14
codename vNext
Support end date: 
Ext. end date: 
14.0.1000.169CU21 (14.0.3335.7, July 2020)
Starting from SQL Server 2017 Service Packs will no longer be released
 SP1SP2SP3SP4
↓ SQL Server 2016
SQL Server 13
Support end date: 
Ext. end date: 
13.0.1601.513.0.4001.0
or 13.1.4001.0
+ CU15
13.0.5026.0
or 13.2.5026.0
+ CU14
↓ SQL Server 2014
SQL Server 12
Support end date: 
Ext. end date: 
12.0.2000.812.0.4100.1
or 12.1.4100.1
+ CU13
12.0.5000.0
or 12.2.5000.0
+ CU18
12.0.6024.0
or 12.3.6024.0
+ CU4
↓ SQL Server 2012
SQL Server 11
codename Denali
Support end date: 
Ext. end date: 
11.0.2100.6011.0.3000.0
or 11.1.3000.0
+ CU16
11.0.5058.0
or 11.2.5058.0
+ CU16
11.0.6020.0
or 11.3.6020.0
+ CU10
11.0.7001.0
or 11.4.7001.0
Obsolete versions – out of support
↓ SQL Server 2008 R2
SQL Server 10.5
codename Kilimanjaro
Support end date: 
Ext. end date: 
10.50.1600.110.50.2500.0
or 10.51.2500.0		10.50.4000.0
or 10.52.4000.0		10.50.6000.34
or 10.53.6000.34
↓ SQL Server 2008
SQL Server 10
codename Katmai
Support end date: 
Ext. end date: 
10.0.1600.2210.0.2531.0
or 10.1.2531.0		10.0.4000.0
or 10.2.4000.0		10.0.5500.0
or 10.3.5500.0		10.0.6000.29
or 10.4.6000.29
↓ SQL Server 2005
SQL Server 9
codename Yukon
Support end date: 
Ext. end date: 
9.0.1399.069.0.20479.0.30429.0.40359.0.5000
↓ SQL Server 2000
SQL Server 8
codename Shiloh
Support end date: 
Ext. end date: 
8.0.1948.0.3848.0.5328.0.7608.0.2039
→ SQL Server 7.0
SQL Server 7
codename Sphinx
Support end date: 
Ext. end date: 
7.0.6237.0.6997.0.8427.0.9617.0.1063
→ SQL Server 6.5
SQL Server 6.50
codename Hydra
Support end date: 
6.50.2016.50.2136.50.2406.50.258SP4 6.50.281
SP5 6.50.416
→ SQL Server 6.0
SQL Server 6
codename SQL95
Support end date: 
6.00.1216.00.1246.00.1396.00.151

Comments

Post a Comment

Popular posts from this blog

MS Office 2013 Activation Command Line

 Microsoft Office Activation Command Line Permanently Activate Microsoft Office 2013 Without Any Software And Product Key Step 1. Open Notepad copy and paste below mention commands and save msoffice.cmd the right click msoffice.cmd and click run as administrator @echo off title Activate Microsoft Office 2013 Volume for FREE!&cls&echo ============================================================================&echo #Project: Activating Microsoft software products for FREE without software&echo ============================================================================&echo.&echo #Supported products:&echo - Microsoft Office 2013 Standard Volume&echo - Microsoft Office 2013 Professional Plus Volume&echo.&echo.&(if exist "%ProgramFiles%\Microsoft Office\Office15\ospp.vbs" cd /d "%ProgramFiles%\Microsoft Office\Office15")&(if exist "%ProgramFiles(x86)%\Microsoft Office\Office15\ospp.vbs" cd /d "%ProgramFiles...
Read more

Matrix Cosec - IN and OUT Events is there but Attendance is not calculate how to rectify?

Image
1).            If employee Events is there but attendance report not showing the event. How to rectify ? Ans:      option 1. Login to Cosec Software and Click Users > User List > Search the User > Click Edit > Select General > Check the Joining Date (If Joining Date greater than current working days Attendance Report not show. After Joining date only attendance report will show)             Option 2. . Login to Cosec Software and Click Users > User List > Search the User > Click Edit > Select T&A > Check Enable Attendance Calculation (If uncheck Enable Attendance Calculation Attendance will not marked the user)             Option 3. Login to Cosec Software and Click Users > User List > Search the User > Click Edit > Select Devices> Uncheck Restrict Atte...
Read more

How to Change Edit 200 Rows and Select Top 1000 Rows Default Value in SQL Server Management Studio

Image
How to Change Edit 200 Rows and Select Top 1000 Rows Default Value in SQL Server Management Studio 1. Login to SQL Server Manatement Studio 2. Go to Tools Menu and Options 4. To make the necessary changes within the Options Dialog box, Expand SQL Server Object Explorer -> Commands. 5. Specify the new value for Value for Edit Top Rows Command and Specify the Value for Select Top Rows Command. In the below example we have set the value as 50 for both options 6. Finally to save the changes click OK to save the changes to SSMS configuration. 7. Once you have made the above mentioned changes right click the table to see the changes as shown in the snippet below
Read more