get the version information of SQL server

Microsoft support has a web page for this.

In short,
1. run 'select @@version'.

Version Number	Service Pack
6.50.479	SQL Server 6.5 Service Pack 5a (SP5a) Update
6.50.416	SQL Server 6.5 Service Pack 5a (SP5a)
6.50.415	SQL Server 6.5 Service Pack 5 (SP5)
6.50.281	SQL Server 6.5 Service Pack 4 (SP4)
6.50.258	SQL Server 6.5 Service Pack 3 (SP3)
6.50.240	SQL Server 6.5 Service Pack 2 (SP2)
6.50.213	SQL Server 6.5 Service Pack 1 (SP1)
6.50.201	SQL Server 6.5 RTM

Version Number	Service Pack
7.00.1063	SQL Server 7.0 Service Pack 4 (SP4)
7.00.961	SQL Server 7.0 Service Pack 3 (SP3)
7.00.842	SQL Server 7.0 Service Pack 2 (SP2)
7.00.699	SQL Server 7.0 Service Pack 1 (SP1)
7.00.623	SQL Server 7.0 RTM (Release To Manufacturing)

if the version number string is started with "8.", "9." or later, then run
"SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')"

The following results are returned:

• The product version (for example, 8.00.534)
• The product level (for example, "RTM" or "SP2")
• The edition (for example, "Standard Edition"). For example, the results resemble the following:
  
  8.00.534 SP2 Standard Edition

Release	Sqlservr.exe
RTM	2000.80.194.0
SQL Server 2000 SP1	2000.80.384.0
SQL Server 2000 SP2	2000.80.534.0
SQL Server 2000 SP3	2000.80.760.0
SQL Server 2000 SP3a	2000.80.760.0
SQL Server 2000 SP4	2000.8.00.2039

9.00.1399.06

RTM

Enterprise Edition

The following table lists the Sqlservr.exe version number.

Release	Sqlservr.exe
RTM	2005.90.1399
SQL Server 2005 Service Pack 1	2005.90.2047
SQL Server 2005 Service Pack 2	2005.90.3042
SQL Server 2005 Service Pack 3	2005.90.4035

10.0.1600.22

RTM

Enterprise Edition

The following table lists the Sqlservr.exe version number.

Collapse this tableExpand this table

Release	Sqlservr.exe
RTM	2007.100.1600.0
SQL Server 2008 Service Pack 1	2007.100.2531.0