Class SqlServerVersions

SQL Server versions. Version numbers are taken from this document: https://support.microsoft.com/en-us/help/321185/how-to-determine-the-version-edition-and-update-level-of-sql-server-an.

Inheritance

System.Object

SqlServerVersions

Namespace: Kros.Data.SqlServer

Assembly: Kros.Utils.dll

Syntax

public static class SqlServerVersions

Fields

Server2005

SQL Server 2005, version 9.00.1399.0.

Declaration

public static readonly Version Server2005

Field Value

Type	Description
System.Version

Server2005SP1

SQL Server 2005 SP1, version 9.00.2047.0.

Declaration

public static readonly Version Server2005SP1

Field Value

Type	Description
System.Version

Server2005SP2

SQL Server 2005 SP2, version 9.00.3042.0.

Declaration

public static readonly Version Server2005SP2

Field Value

Type	Description
System.Version

Server2005SP3

SQL Server 2005 SP3, version 9.00.4035.0.

Declaration

public static readonly Version Server2005SP3

Field Value

Type	Description
System.Version

Server2005SP4

SQL Server 2005 SP4, version 9.00.5000.0.

Declaration

public static readonly Version Server2005SP4

Field Value

Type	Description
System.Version

Server2008

SQL Server 2008, version 10.00.1600.22.

Declaration

public static readonly Version Server2008

Field Value

Type	Description
System.Version

Server2008R2

SQL Server 2008 R2, version 10.50.1600.1.

Declaration

public static readonly Version Server2008R2

Field Value

Type	Description
System.Version

Server2008R2SP1

SQL Server 2008 R2 SP1, version 10.50.2500.0.

Declaration

public static readonly Version Server2008R2SP1

Field Value

Type	Description
System.Version

Server2008R2SP2

SQL Server 2008 R2 SP2, version 10.50.4000.0.

Declaration

public static readonly Version Server2008R2SP2

Field Value

Type	Description
System.Version

Server2008R2SP3

SQL Server 2008 R2 SP3, version 10.50.6000.34.

Declaration

public static readonly Version Server2008R2SP3

Field Value

Type	Description
System.Version

Server2008SP1

SQL Server 2008 SP1, version 10.00.2531.00.

Declaration

public static readonly Version Server2008SP1

Field Value

Type	Description
System.Version

Server2008SP2

SQL Server 2008 SP2, version 10.00.4000.00.

Declaration

public static readonly Version Server2008SP2

Field Value

Type	Description
System.Version

Server2008SP3

SQL Server 2008 SP3, version 10.00.5500.00.

Declaration

public static readonly Version Server2008SP3

Field Value

Type	Description
System.Version

Server2012

SQL Server 2012, version 11.0.2100.60.

Declaration

public static readonly Version Server2012

Field Value

Type	Description
System.Version

Server2012SP1

SQL Server 2012 SP1, version 11.0.3000.00.

Declaration

public static readonly Version Server2012SP1

Field Value

Type	Description
System.Version

Server2012SP2

SQL Server 2012 SP2, version 11.0.5058.0.

Declaration

public static readonly Version Server2012SP2

Field Value

Type	Description
System.Version

Server2012SP3

SQL Server 2012 SP3, version 11.0.6020.0.

Declaration

public static readonly Version Server2012SP3

Field Value

Type	Description
System.Version

Server2012SP4

SQL Server 2012 SP4, version 11.0.7001.0.

Declaration

public static readonly Version Server2012SP4

Field Value

Type	Description
System.Version

Server2014

SQL Server 2014, version 12.0.2000.8.

Declaration

public static readonly Version Server2014

Field Value

Type	Description
System.Version

Server2014SP1

SQL Server 2014 SP1, version 12.0.4100.1.

Declaration

public static readonly Version Server2014SP1

Field Value

Type	Description
System.Version

Server2014SP2

SQL Server 2014 SP2, version 12.0.5000.0.

Declaration

public static readonly Version Server2014SP2

Field Value

Type	Description
System.Version

Server2016

SQL Server 2016, version 13.0.2149.0.

Declaration

public static readonly Version Server2016

Field Value

Type	Description
System.Version

Server2016SP1

SQL Server 2016 SP1, version 13.0.4001.0.

Declaration

public static readonly Version Server2016SP1

Field Value

Type	Description
System.Version

Server2016SP2

SQL Server 2016 SP2, version 13.0.5026.0.

Declaration

public static readonly Version Server2016SP2

Field Value

Type	Description
System.Version

Server2017

SQL Server 2017, version 14.0.3006.16.

Declaration

public static readonly Version Server2017

Field Value

Type	Description
System.Version