KBA-01268: SQL Server Versions with Service Packs

Summary:

SQL Server Versions

This great chart is from http://sqlserverbuilds.blogspot.com/ (excessive advertising notwithstanding)

See also https://support.microsoft.com/en-us/kb/321185

You can determine what version SQL Server is running by using this Query:
Select @@version, @@MICROSOFTVERSION
@@Version is a system level variable that holds the current version.  Likewise, @@MICROSOFTVERSION is a simple numeric that indicates the release and service level.


KBA-01268; Last updated: April 24, 2017 at 11:23 am;