MS SQL Server Version History – Year Wise
MS SQL Server is a RDBMS (Relational Database Management System) which is developed by Microsoft.
Here we will go through a series of different versions of SQL Server with specified year when it was launched\born.
Being a DBA we must know which version we are working on and what were the previous versions because this knowledge will help us to solve the compatibility issues in SQL Server.
SQL Server Release History
|SQL Server 1.0 (16-bit)||1.0||1989|
|SQL Server 1.1 (16-bit)||1.1||1991|
|SQL Server 4.2A (16-bit)||4.2A||1992|
|SQL Server 4.2B (16-bit)||4.2B||1993|
|SQL Server 6.0||6.0||1995|
|SQL Server 6.5||6.5||1996|
|SQL Server 7.0||7.0||1998|
|SQL Server 2000||8.0||2000|
|SQL Server 2005||9.0||2005|
|SQL Server 2008||10.0||2008|
|SQL Server 2008 R2||10.50||2010|
|SQL Server 2012||11.0||2012|
|SQL Server 2014||12.0||2014|
|SQL Server 2016||13.0||2016|
|SQL Server vNext||14.0||2017|
Command to check version in SSMS-