SQL Server 2000 and earlier versions

You can determine what version SQL Server is running by running

Select @@version

@ Version is a system level variable that holds the current version. On my computer this returns

SQL Server Versions

@ Version	SQL Server Version	Released
6.50.201	SQL Server 6.5 RTM
6.50.213	SQL Server 6.5 with Service Pack 1
6.50.240	SQL Server 6.5 with Service Pack 2
6.50.258	SQL Server 6.5 with Service Pack 3
6.50.281	SQL Server 6.5 with Service Pack 4
6.50.415	SQL Server 6.5 with Service Pack 5
6.50.416	SQL Server 6.5 with Service Pack 5a
7.00.623	SQL Server 7.0/MSDE 1.0 RTM
7.00.699	Web SQL Server 7.0 SP1	July 1999
7.00.842	Web SQL Server 7.0 SP2	March 20 th, 2000
7.00.961	Web SQL Server 7.0 SP3	December 15th, 2000
7.00.1063	Web SQL Server 7.0 SP4
8.00.194	SQL Server 2000 RTM
8.00.384	Web SQL Server 2000 SP1
8.00.534	Web SQL Server 2000 SP2	November 30 th, 2001
8.00.760	Web SQL Server 2000 SP3

Analysis Services

You can determine the OLAP version by starting the OLAP Manager. Click on the Servers node in the tree view and click on About Microsoft SQL Server OLAP Services. The versions are listed below:

Help About	SQL Server OLAP Services version
7.0.1073	SQL Server 7.0 OLAP RTM
7.0.1295	OLAP Services SP1
7.0.1458	OLAP Services SP2
7.0.1508	OLAP Services SP3
8.0.194	SQL Server 2000 Analysis Services RTM
8.0.382	Analysis Services SP1
8.0.532	Analysis Services SP2