KBA-01268: SQL Server Versions with Service Packs


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: November 18, 2020 at 15:20 pm;